将XML文件导入到MYSQL表中，并将元素标签解析为列标题和值

import xml.etree.ElementTree as ET
import MySQLdb

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

# 创建MYSQL连接
db = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database')
cursor = db.cursor()

# 创建MYSQL表
table_name = 'xml_data'
create_table_query = 'CREATE TABLE IF NOT EXISTS {} (id INT AUTO_INCREMENT PRIMARY KEY)'.format(table_name)
cursor.execute(create_table_query)

# 遍历XML树并插入数据
for child in root:
    column_name = child.tag
    column_value = child.text
    
    # 将XML元素标签解析为列标题和值，并插入MYSQL表中
    insert_query = "INSERT INTO {} ({}) VALUES ('{}')".format(table_name, column_name, column_value)
    cursor.execute(insert_query)

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