循环通过表来制作json

SELECT * FROM users;

import json
import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name')
cursor = conn.cursor()

# 查询数据
cursor.execute('SELECT * FROM users')

# 获取查询结果
results = cursor.fetchall()

# 将查询结果转换为JSON格式
json_data = []
for row in results:
    json_data.append({
        'id': row[0],
        'name': row[1],
        'age': row[2],
        'email': row[3]
    })

# 输出JSON格式数据
print(json.dumps(json_data))

[
    {
        "id": 1,
        "name": "张三",
        "age": 25,
        "email": "zhangsan@example.com"
    },
    {
        "id": 2,
        "name": "李四",
        "age": 30,
        "email": "lisi@example.com"
    }
]