python查询mysql表

import pymysql

conn = pymysql.connect(host="localhost",port=3306,user="root",password="mysql",db="smy_db")
cur = conn.cursor()

sql_0="describe score;"
sql_1="select * from score;"
sql_2="select * from score where score>80;"

flag=1 #第一次先让flag=0，显示score表的结构，第二次让其非0，根据score表结构修改sql_1,并显示修改结果

if flag==0:
    cur.execute(sql_0)
    data = cur.fetchall()
    print(data)
    cur.execute(sql_1)
    data = cur.fetchall()
    print(data)
else:
    try:
        cur.execute(sql_2) # 执行sql语句
        data = cur.fetchall()
        for i in data:
            print("%s------%s"%(i[1],i[3]))
    except:
        conn.rollback() # 如果发生错误则回滚

cur.close()#关闭游标
conn.close()#释放数据库资源