前言
pymysql在操作mysql数据库时候,update了数据之后select拿到的一直都是老数据
r1
python的pymysql默认不是自动提交事务
MySQL是自动提交事务的
con = connect(host = 'localhost', port = 3306, database = '123', user = '123', password = '123', charset = 'utf8’, autocommit = 1)
r2
在每次select之后commit
con = connect(host = 'localhost', port = 3306, database = '123', user = '123', password = '123', charset = 'utf8')
cs = con.cursor()
sql = 'select * from xxx where id = 1'
cs.execute(sql)
con.commit()
print(cs.fetchone())
cs.execute(sql)
con.commit()
print(cs.fetchone())
参考文章
https://blog.csdn.net/weixin_48419914/article/details/122151844