python面试之mysql

python在mysql中执行事务

# 导入pymysql模块
import pymysql

# 连接数据库
conn = pymysql.connect(host="***", user="***",password="***",database="***",charset="utf8")

# 得到一个可以执行SQL语句的光标对象
cursor = conn.cursor()

# 修改数据的SQL语句
sql = "UPDATE T_USER_INFO SET EMAIL=%s WHERE USER_ID=%s;"

userId = "2c92b3df633ee9fc01633f6014490001"
email = "333"

try:
    # 执行SQL语句
    cursor.execute(sql, [email, userId])
    # 提交事务
    conn.commit()
except Exception as e:
    # 有异常，回滚事务
    conn.rollback()
    print(e)
    
#关闭光标
cursor.close()

#关闭连接
conn.close()