mysql导出csv乱码

SELECT * INTO OUTFILE '/path/to/your/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
CHARACTER SET utf8mb4;

mysqldump --compatible=ansi --compact --no-create-info --skip-extended-insert --fields-terminated-by=',' --fields-enclosed-by='"' --lines-terminated-by='\n' --default-character-set=utf8mb4 your_database your_table > /path/to/your/file.csv

file -i /path/to/your/file.csv
iconv -f utf8mb4 -t utf8 /path/to/your/file.csv -o /path/to/your/file_utf8.csv

import mysql.connector
import csv

# 连接MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database",
    charset='utf8mb4'
)

cursor = db.cursor()

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

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

cursor.close()
db.close()