pymysql更新数据

更新数据

import pymysql
db = pymysql('localhost', 'root', '123456', 'heimdall')
cursor = db.cursor()

• 用于更新数据的sql语句
  update = "UPDATE employee SET age = age + 1 WHERE sex= '男'"

• 发生错误就回滚
  try: cursor.execute(update) db.commit() except: db.rollcack()

db.close()