pymysql
pip install pymysql
import pymysql
import time
from pymysql.constants import CLIENT
# 连接数据库
db = pymysql.connect(
host="localhost",
port=3306,
user="root",
password="123456",
client_flag=CLIENT.MULTI_STATEMENTS, # 添加client_flag参数
database="azure"
# database="azure"
)
# 创建游标
result = db.cursor()
# 查询
def dbExecuteQuery(sqlStatment):
result.execute(sqlStatment)
return result.fetchall()
# 修改
def dbExecuteModify(sqlStatment):
result.execute(sqlStatment)
db.commit()
# print(result.fetchall())