如何将可重复的XML子标签导入一个mysql列

import xml.etree.ElementTree as ET
import mysql.connector

# 解析XML文件
tree = ET.parse('data.xml')
root = tree.getroot()

# 连接MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
cursor = cnx.cursor()

# 创建表
create_table_query = "CREATE TABLE IF NOT EXISTS xml_data (id INT AUTO_INCREMENT PRIMARY KEY, data VARCHAR(255))"
cursor.execute(create_table_query)

# 提取子标签数据并插入到MySQL表中
for child in root:
    data = child.text
    insert_query = "INSERT INTO xml_data (data) VALUES (%s)"
    cursor.execute(insert_query, (data,))

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