将Python字典与MySQL表连接起来

import pymysql

# 连接MySQL数据库
conn = pymysql.connect(host='localhost', user='root', password='password', database='test')

# 创建游标对象
cursor = conn.cursor()

# 定义字典数据
data = {'name': 'John', 'age': 25, 'city': 'New York'}

# 将字典数据插入MySQL表
sql = "INSERT INTO users (name, age, city) VALUES (%s, %s, %s)"
cursor.execute(sql, (data['name'], data['age'], data['city']))
conn.commit()

# 查询MySQL表中的数据并转换为字典
sql = "SELECT * FROM users"
cursor.execute(sql)
result = cursor.fetchall()

# 将查询结果转换为字典列表
dict_list = []
for row in result:
    dict_list.append({'name': row[0], 'age': row[1], 'city': row[2]})

# 关闭游标和数据库连接
cursor.close()
conn.close()

# 打印字典列表
print(dict_list)