将单个Json文件数据保存到同一SQL DB中的两个不同表中

import json
import mysql.connector

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

# 连接MySQL数据库
db = mysql.connector.connect(
  host="localhost",
  user="username",
  password="password",
  database="database_name"
)

# 创建两个表
cursor = db.cursor()
cursor.execute("CREATE TABLE IF NOT EXISTS table1 (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), age INT)")
cursor.execute("CREATE TABLE IF NOT EXISTS table2 (id INT AUTO_INCREMENT PRIMARY KEY, address VARCHAR(255), email VARCHAR(255))")

# 插入数据到table1
for data in json_data:
    name = data['name']
    age = data['age']
    cursor.execute("INSERT INTO table1 (name, age) VALUES (%s, %s)", (name, age))

# 插入数据到table2
for data in json_data:
    address = data['address']
    email = data['email']
    cursor.execute("INSERT INTO table2 (address, email) VALUES (%s, %s)", (address, email))

# 提交更改到数据库
db.commit()

# 关闭数据库连接
db.close()