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()

posted @   咖啡馆  阅读(759)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示