import pymysql
# 数据库更新操作
db = pymysql.connect("localhost", "root", "wsw..177122", "wakey")
cursor = db.cursor()
sql = 'update boy set age=30 where id = 1'
try:
res = cursor.execute(sql)
db.commit()
print(res)
except:
db.rollback()
cursor.close()
db.close()