如何将序列化数据插入数据库？

import json
import mysql.connector

# 序列化数据
data = {
    "name": "John",
    "age": 30,
    "city": "New York"
}
serialized_data = json.dumps(data)

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

# 创建数据库表（如果需要）
cursor = cnx.cursor()
create_table_query = "CREATE TABLE IF NOT EXISTS serialized_data (id INT AUTO_INCREMENT PRIMARY KEY, data JSON)"
cursor.execute(create_table_query)

# 插入数据
insert_query = "INSERT INTO serialized_data (data) VALUES (%s)"
cursor.execute(insert_query, (serialized_data,))

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