pymysql -python3的mysql库
最后更新于：2022-04-02 02:16:48
[TOC]
## pymysql -python3的mysql库
### 事务回滚
```python
import pymysql.cursors
connection = pymysql.connect(host='localhost', user='root', password='root', db='test', charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor)
try:
with connection.cursor() as cursor:
sql = "INSERT INTO `urllist` (`urlname`, `urlhref`) VALUES (%s, %s)"
cursor.execute(sql, ('webmaster@python.org', 'very-secret'))
print(cursor.rowcount) #受影响条数
sql = "UPDATE `urllist` set urlname=%s,urlhref=%s where id=%s"
cursor.execute(sql, ('cpjupdate', 'hrefupadte', '13'))
print(cursor.rowcount)
connection.commit()
except Exception as e:
connection.rollback()
print("mysq:", e)
finally:
connection.close()
```
';