import pymysql
db=pymysql.connect(host,user,passwd,database)
cursor=db.cursor(pymysql.cursors.DictCursor) #结果以字典返回
sql="select avg(salary) from department group by depart order by avg(salary) desc limit(5,6)"
try:
cursor.execute(sql)
cursor.commit() # 增删改操作需要提交
result=cursor.fetchall()
print(result)
except:
cursor.rollback() # 增删改操作失败需要回退
print("查找失败")
cursor.close()
db.close()
python 操作数据库
最新推荐文章于 2023-06-25 22:19:43 发布