如何将JSON中的数据插入SQL数据库

import json
import mysql.connector

# 解析JSON数据
json_data = '''
{
  "name": "John",
  "age": 30,
  "email": "john@example.com"
}
'''
data = json.loads(json_data)

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

# 创建SQL插入语句
insert_query = "INSERT INTO table_name (name, age, email) VALUES (%s, %s, %s)"

# 绑定参数并执行插入操作
cursor = cnx.cursor()
cursor.execute(insert_query, (data['name'], data['age'], data['email']))
cnx.commit()

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