mysql如何导入xml文件

<employees>
    <employee>
        <id>1</id>
        <name>John Doe</name>
        <position>Developer</position>
    </employee>
    <employee>
        <id>2</id>
        <name>Jane Smith</name>
        <position>Designer</position>
    </employee>
</employees>

CREATE DATABASE IF NOT EXISTS mydb;
USE mydb;

CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    position VARCHAR(255)
);

import xml.etree.ElementTree as ET
import csv

tree = ET.parse('data.xml')
root = tree.getroot()

with open('data.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(['id', 'name', 'position'])
    for employee in root.findall('employee'):
        id = employee.find('id').text
        name = employee.find('name').text
        position = employee.find('position').text
        writer.writerow([id, name, position])

LOAD DATA INFILE 'data.csv'
INTO TABLE employees
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';