1.安装pymysql命令
sudo pip3 install pymysql
2.通过pymysql操作数据库的步骤
2.1对数据表的读操作
# 导入模块 from pymysql import *
# 创建连接对象 连接数据库 conn = connect(host="127.0.0.1", port=3306, user="root", password="mysql", database="jing_dong") |
sudo pip3 install pymysql
# 导入模块 from pymysql import *
# 创建连接对象 连接数据库 conn = connect(host="127.0.0.1", port=3306, user="root", password="mysql", database="jing_dong") |