import pymysql
db = pymysql.connect(
host='172.16.26.139',
user='root',
password='******',
port=3306,
database='testpy')
cursor = db.cursor()
id = '2022003'
name = 'bobo2'
age = 22
sql = 'INSERT INTO testt (id,name,age) values (%s,%s,%s)'
try:
cursor.execute(sql, (id, name, age))
db.commit()
except:
db.rollback()
db.close()
插入、更新和删除是对数据库进行的更改操作,更改操作必须是一个事务,所以标准写法是:
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()