将xml导入mysql数据库

xmllint --noout yourfile.xml

import xml.sax

class MyHandler(xml.sax.ContentHandler):
    def startElement(self, name, attrs):
        print("Start element:", name)
        for attr in attrs.getNames():
            print("Attribute:", attr, "=", attrs.getValue(attr))

parser = xml.sax.make_parser()
parser.setContentHandler(MyHandler())
parser.parse("yourfile.xml")

LOAD DATA INFILE 'yourfile.xml'
INTO TABLE your_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

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

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

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

for child in root:
    # 假设XML结构为：<record><id>1</id><name>John</name></record>
    id = child.find('id').text
    name = child.find('name').text
    
    # 插入数据到MySQL
    sql = "INSERT INTO your_table (id, name) VALUES (%s, %s)"
    val = (id, name)
    cursor.execute(sql, val)

# 提交事务
db.commit()

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