json数据导入mysql数据库

import json
import pymysql

# JSON数据
json_data = '''
[
    {
        "name": "Alice",
        "age": 25,
        "email": "alice@example.com"
    },
    {
        "name": "Bob",
        "age": 30,
        "email": "bob@example.com"
    }
]
'''

# 解析JSON数据
data = json.loads(json_data)

# 连接到MySQL数据库
conn = pymysql.connect(host='localhost', user='username', password='password', database='database_name')
cursor = conn.cursor()

# 创建表
create_table_sql = '''
CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    age INT,
    email VARCHAR(50)
)
'''
cursor.execute(create_table_sql)

# 插入数据
insert_sql = 'INSERT INTO users (name, age, email) VALUES (%s, %s, %s)'
for item in data:
    values = (item['name'], item['age'], item['email'])
    cursor.execute(insert_sql, values)

# 提交事务并关闭连接
conn.commit()
cursor.close()
conn.close()