如何将以逗号分隔的数据添加到数据库中

import mysql.connector

# 解析数据
data = "data1,data2,data3"
items = data.split(",")

# 连接数据库
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 (id INT AUTO_INCREMENT PRIMARY KEY, data VARCHAR(255))"
cursor.execute(create_table_query)

# 插入数据
insert_query = "INSERT INTO my_table (data) VALUES (%s)"
for item in items:
    cursor.execute(insert_query, (item,))

# 提交事务
cnx.commit()

# 关闭连接
cursor.close()
cnx.close()