如何将带有分隔符的一个表中的一列分解为新表中的多个列？

import mysql.connector

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

# 创建游标对象
cursor = cnx.cursor()

# 查询原始表中的数据
query = "SELECT column_name FROM original_table"
cursor.execute(query)

# 遍历查询结果
for row in cursor:
    # 拆分原始列并生成新的列列表
    split_columns = row[0].split(',')

    # 创建新表并插入拆分后的列
    create_table_query = "CREATE TABLE new_table ("
    insert_data_query = "INSERT INTO new_table VALUES ("

    for column in split_columns:
        create_table_query += column + " VARCHAR(255), "
        insert_data_query += "%s, "

    create_table_query = create_table_query.rstrip(', ') + ")"
    insert_data_query = insert_data_query.rstrip(', ') + ")"

    cursor.execute(create_table_query)
    cursor.execute(insert_data_query, split_columns)

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