mysql 导出cvs乱码

mysqldump -u username -p --default-character-set=utf8 --compatible=ansi --skip-extended-insert --compact database_name table_name > output.csv

import csv
import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='username', password='password', db='database_name', charset='utf8mb4')
cursor = conn.cursor()

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

# 导出CSV文件
with open('output.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()
conn.close()

-- 查看数据库字符集
SHOW CREATE DATABASE database_name;

-- 查看表字符集
SHOW CREATE TABLE table_name;

-- 修改数据库字符集
ALTER DATABASE database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 修改表字符集
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;