获取json值并将其存储在我的表中，并使用某个特定的模式

import json
import mysql.connector

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

# 提取所需的值
name = data['name']
age = data['age']
city = data['city']

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

# 创建表
create_table_query = '''
    CREATE TABLE IF NOT EXISTS my_table (
        name VARCHAR(50),
        age INT,
        city VARCHAR(50)
    )
'''
cursor.execute(create_table_query)

# 存储数据
insert_query = '''
    INSERT INTO my_table (name, age, city) VALUES (%s, %s, %s)
'''
cursor.execute(insert_query, (name, age, city))

# 提交更改并关闭连接
cnx.commit()
cursor.close()
cnx.close()