python 之 PyMySQL

python库

参考：

API文档

pymysql文档

安装

pip install PyMySQL
import pymysql

连接

connection = pymysql.connect(host='localhost',
                             user='user_name',
                             password='passwd',
                             db='database_name',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

Connection对象

connection.close

connection.close()   # 关闭连接

connection.commit

connection.commit()   # 将操作提交到数据库

connection.rollback

connection.rollback()  # 数据库回滚

Cursor对象

获取Cursor对象

cursor = connection.cursor()  # 返回Cursor对象

cursor.excete

sql = "sql语句"
cursor.execute(sql)