mysql导出csv格式乱

SELECT * INTO OUTFILE '/path/to/output.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM your_table;

SELECT * INTO OUTFILE '/path/to/output.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM your_table;

mysqldump -u username -p --compatible=ansi --skip-extended-insert --compact --no-create-info --skip-quote-names --skip-comments --skip-dump-date -t -T/path/to/ your_database your_table --fields-terminated-by=',' --fields-enclosed-by='"' --fields-escaped-by='\\'

import mysql.connector
import csv

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

# 查询数据
query = "SELECT * FROM your_table"
cursor.execute(query)

# 导出为CSV文件
with open('/path/to/output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    csvwriter = csv.writer(csvfile)
    csvwriter.writerow([i[0] for i in cursor.description])  # 写入列名
    csvwriter.writerows(cursor)

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