pymysql安全回滚操作

74 阅读 0 评论 49 点赞

我是靠谱客的博主高挑饼干，最近开发中收集的这篇文章主要介绍pymysql安全回滚操作，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

db = pymysql.connect(user='root', password='mysql', database='test', host='127.0.0.1', port=3306, charset='utf8mb4')
name_list = ["re", "gh", "ds", "D"]
# 存储name的值
age_list = ["10", "20", "30", "40"]
# 存储age的值
id_list = ["1", "2", "3", "4"]
# 存储id的值
val_list = [[name_list[i], age_list[i], id_list[i]] for i in range(len(id_list))]
print(val_list)
#[['re', '10', '1'], ['gh', '20', '2'], ['ds', '30', '3'], ['D', '40', '4']]
with db.cursor() as cursor:
try:
sql = "UPDATE test SET name=(%s), age=(%s) WHERE id=(%s)"
cursor.executemany(sql, val_list)
db.commit()
except:
db.rollback()
db.close()