如何将元素从以逗号分隔的嵌套JSON数组装载到SQL表中

import json
import mysql.connector

# 解析JSON数据
json_data = '[{"name": "John", "age": 25, "skills": "HTML,CSS,JavaScript"}, {"name": "Jane", "age": 30, "skills": "Python,SQL"}]'
data = json.loads(json_data)

# 创建SQL表
create_table_query = "CREATE TABLE IF NOT EXISTS users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), age INT, skill VARCHAR(255))"
connection = mysql.connector.connect(host='localhost', user='username', password='password', database='database_name')
cursor = connection.cursor()
cursor.execute(create_table_query)

# 插入数据
insert_query = "INSERT INTO users (name, age, skill) VALUES (%s, %s, %s)"
for item in data:
    skills = item['skills'].split(',')
    values = (item['name'], item['age'], skills)
    cursor.execute(insert_query, values)

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