1.pymysql安装
安装:pip install pymysql
补充命令:
查看当前已经安装的所有模块和库:pip list
卸载pymysql库:pip uninstall pymysql
更新某个库:pip install 库名 -U
2.pymysql基础操作
import pymysql # 创建连接 conn = pymysql.connect(host='127.0.0.1', port=3306, user='blog', passwd='123456', db='blog', charset='utf8') # 创建游标, 查询数据默认为元组类型 cursor = conn.cursor() # 执行SQL,并返回收影响行数 row1 = cursor.execute("update users set password = '123'") print(row1) # 执行SQL,并返回受影响行数 row2 = cursor.execute("update users set password = '456' where id > %s", (1,)) print(row2) # 执行SQL,并返回受影响行数(使用pymysql的参数化语句防止SQL注入) row3 = cursor.executemany("insert into users(username, password, email)values(%s, %s, %s)", [("ceshi3", '333', 'ceshi3@11.com'), ("ceshi4", '444', 'ceshi4@qq.com')]) print(row3) # 提交,不然无法保存新建或者修改的数据 conn.commit() # 关闭游标 cursor.close() # 关闭连接 conn.close()