将解析的json数据插入到MySQL表中

import json
import pymysql

# 解析JSON数据
json_data = '''
{
  "name": "John",
  "age": 30,
  "city": "New York"
}
'''
data = json.loads(json_data)

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

# 创建表（如果表不存在）
create_table_query = '''
CREATE TABLE IF NOT EXISTS users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  age INT,
  city VARCHAR(255)
)
'''
cursor.execute(create_table_query)

# 插入数据
insert_query = '''
INSERT INTO users (name, age, city) VALUES (%s, %s, %s)
'''
cursor.execute(insert_query, (data['name'], data['age'], data['city']))

# 提交事务
conn.commit()

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