1.安装:
a.手动安装:
pip install PyMySQL
b.自动安装:
下载pymysql,然后解压压缩包。在命令行中进入解压后的目录,执行如下的指令:
python setup.py install
2. mysql 操作流程:
3.connection 对象:
import pymysql print(pymysql) db = pymysql.connect(host = "127.0.0.1", port = 3306, user = "root", password = "123456", db = "python", charset="utf8" )
4.cursor 对象:
cursor = db.cursor() sql = "select * from company " cursor.execute(sql) for cur in cursor.fetchall() : print("%d %s "%cur)5.异常处理:
connection.commit()
connection.rollback()