从json文件添加到mysql db中的数据

import json
import pymysql

# 读取JSON文件
with open('data.json', 'r') as file:
    json_data = json.load(file)

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

# 创建数据表
create_table_query = '''
CREATE TABLE IF NOT EXISTS table_name (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255),
    age INT
)
'''
cursor.execute(create_table_query)

# 插入数据
insert_query = 'INSERT INTO table_name (name, age) VALUES (%s, %s)'
for item in json_data:
    cursor.execute(insert_query, (item['name'], item['age']))

# 提交事务
conn.commit()

# 关闭连接
cursor.close()
conn.close()