import pymysql
from pymysql.cursors import DictCursor
while True:
name = input("输入想要查询name:")
if name.upper()=="Q":
break
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',password='123456',charset='utf8',database='moms')
cursor = conn.cursor(cursor = DictCursor)
sql = "select * from class_demo where name = %s"
cursor.execute(sql,["展示"])
data = cursor.fetchall()
print(data)
cursor.close()
conn.close()
pymsql如何查询数据库以字典形式 返回表内容
于 2023-06-24 10:40:05 首次发布