使用Python将JSON数据插入MySQL数据库时出现问题，SQL语法错误

import mysql.connector
import json

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 假设我们有一个JSON字符串
json_data = '{"name": "John", "age": 30, "city": "New York"}'

# 将JSON字符串转换为Python字典
data = json.loads(json_data)

# 构建SQL语句
sql = "INSERT INTO yourtable (data) VALUES (%s)"
values = (json.dumps(data),)

# 执行SQL语句
cursor.execute(sql, values)

# 提交事务
db.commit()

print(cursor.rowcount, "record inserted.")

# 假设JSON数据中的"age"字段应该是整数类型
data['age'] = int(data['age'])

# 构建SQL语句
sql = "INSERT INTO yourtable (name, age, city) VALUES (%s, %s, %s)"
values = (data['name'], data['age'], data['city'])

# 执行SQL语句
cursor.execute(sql, values)

# 提交事务
db.commit()

print(cursor.rowcount, "record inserted.")

try:
    db = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )
except mysql.connector.Error as err:
    print(f"Error: {err}")