如何使用python3将变更模式json插入到mysql中？

import json
import mysql.connector

cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
cursor = cnx.cursor()

with open('path/to/your/json_file.json') as file:
    data = json.load(file)

for item in data:
    query = "INSERT INTO your_table (column1, column2, ...) VALUES (%s, %s, ...)"
    values = (item['field1'], item['field2'], ...)
    cursor.execute(query, values)

cnx.commit()
cursor.close()
cnx.close()