#提示1050请补上这句话 如果存在表user先删除它 加上这句话意味可以二次运行程序
cursor.execute("drop table if exists user")
cursor.execute("create table user(id int primary key, name varchar(20), score int)")
cursor.execute(r"insert into user values (001, 'Adam', 95)")
cursor.execute(r"insert into user values (002, 'Bart', 62)")
cursor.execute(r"insert into user values (003, 'Lisa', 78)")
cursor.close()
conn.commit()
conn.close()
def get_score_in(low, high):
conn=pymysql.connect('localhost','root','','test')
cursor=conn.cursor()
try:
#mysql中请使用%s代替数据
cursor.execute(r"select name from user where score>=%s and score<=%s order by score",(low,high))
reslut=cursor.fetchall()
return [name[0] for name in reslut]
finally:
cursor.close()
conn.close()
南柯一梦兯
import pymysql
#提示1049 请先到外部使用数据库创建一个test数据库 conn = pymysql.connect('localhost','root','','test') cursor = conn.cursor() #创建光标
#提示1050请补上这句话 如果存在表user先删除它 加上这句话意味可以二次运行程序 cursor.execute("drop table if exists user") cursor.execute("create table user(id int primary key, name varchar(20), score int)") cursor.execute(r"insert into user values (001, 'Adam', 95)") cursor.execute(r"insert into user values (002, 'Bart', 62)") cursor.execute(r"insert into user values (003, 'Lisa', 78)") cursor.close() conn.commit() conn.close()
def get_score_in(low, high): conn=pymysql.connect('localhost','root','','test') cursor=conn.cursor() try: #mysql中请使用%s代替数据 cursor.execute(r"select name from user where score>=%s and score<=%s order by score",(low,high)) reslut=cursor.fetchall() return [name[0] for name in reslut] finally: cursor.close() conn.close()