如何将多值字符分隔的列拆分成多行？

import mysql.connector

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

# 查询包含多值字符的列
query = "SELECT id, multi_value_column FROM table_name"
cursor.execute(query)

for (id, multi_value_column) in cursor:
    # 使用逗号作为分隔符拆分多值字符
    values = multi_value_column.split(',')

    for value in values:
        # 插入拆分后的值到新的行
        insert_query = "INSERT INTO new_table (id, single_value_column) VALUES (%s, %s)"
        cursor.execute(insert_query, (id, value))

# 提交事务并关闭连接
cnx.commit()
cursor.close()
cnx.close()