import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="user",
passwd="passwd",
database = 'database '
)
# 这里加入 dictionary=True 将默认返回值类型 转换为 字典类型
mycursor = mydb.cursor(dictionary=True)
mycursor.execute("SELECT * FROM `test`")
myresult = mycursor.fetchall()
for x in myresult:
print(x)
# 查询结果
{'id': 1 }
{'id': 2 }