python-mysql事务操作

Mysql事务特性见：mysql-事务

python 对事务的操作：

import pymysql
## 链接数据库
conn = pymysql.connect(user='root', password='123', host='127.0.0.1', port=3306, charset='utf8', database='db')
cursor = conn.cursor()
## 开启事务
conn.begin()

try:
    cursor.execute("insert into Phone_table values (12,'Tom')")
except Exception as e:
    print('事务回滚')
    conn.rollback()
else:
    print('事务提交')
    conn.commit()

cursor.close()
conn.close()