MySQL的事务操作--python

打开一个MySQL连接con和游标cursor

con = pymysql.connect(host=DB_HOST, user=DB_USER, passwd=DB_PASSWORD, db=DB_NAME, port=DB_PORT, charset='utf8')
cursor = con.cursor()

然后再规定两个操作

sql_select = "select * from table_name
cursor.execute(sql_select)
tup = cursor.fetchone()

sql_update = "update table_name set name='new_name' where id={select_id}".formate(select_id =tup['id'])
cursor.execute(sql_update)

con.commit()

如果操作失败记得回滚操作

con.rollback()