mysql返回xml格式

import mysql.connector
from xml.etree.ElementTree import Element, SubElement, tostring

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

cursor = db.cursor()

# 执行查询
cursor.execute("SELECT * FROM yourtable")

# 获取查询结果
rows = cursor.fetchall()

# 将查询结果转换为XML格式
root = Element('data')
for row in rows:
    record = SubElement(root, 'record')
    for i, value in enumerate(row):
        field = SubElement(record, 'field', attrib={'name': f'column{i+1}'})
        field.text = str(value)

xml_data = tostring(root, encoding='unicode')

print(xml_data)

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

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase",
    charset='utf8mb4'
)

xml_data = tostring(root, encoding='unicode')