mysql导出cdm文件

mysqldump -u username -p database_name --compatible=ansi --skip-extended-insert --compact --no-create-info --skip-quote-names --fields-terminated-by=',' --fields-enclosed-by='"' --lines-terminated-by='
' > output.csv

SELECT JSON_OBJECT('column1', column1, 'column2', column2)
INTO OUTFILE '/path/to/output.json'
FROM table_name;

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

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password', host='host', database='database_name')
cursor = cnx.cursor()

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

# 创建XML根元素
root = ET.Element("data")

# 遍历查询结果并添加到XML树中
for row in cursor:
    record = ET.SubElement(root, "record")
    for i, value in enumerate(row):
        field = ET.SubElement(record, f"field{i+1}")
        field.text = str(value)

# 将XML树写入文件
tree = ET.ElementTree(root)
tree.write("/path/to/output.xml")

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

GRANT SELECT, LOCK TABLES, SHOW VIEW ON database_name.* TO 'username'@'host';
FLUSH PRIVILEGES;

mkdir -p /path/to/output
chmod 755 /path/to/output

mysqldump -u username -p database_name --default-character-set=utf8mb4 --compatible=ansi --skip-extended-insert --compact --no-create-info --skip-quote-names --fields-terminated-by=',' --fields-enclosed-by='"' --lines-terminated-by='
' > output.csv