如何从JSON结构向MySQL列插入多行

import mysql.connector
import json

# 解析JSON数据
json_data = '''
[
    {"name": "John", "age": 28},
    {"name": "Emma", "age": 25},
    {"name": "Tom", "age": 30}
]
'''
data = json.loads(json_data)

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

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

# 创建表和列（如果需要）

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

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