导入mysql数据中文乱码

ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

SET NAMES utf8mb4;

import pymysql

conn = pymysql.connect(host='your_host', user='your_user', password='your_password', db='your_database', charset='utf8mb4')

mysql -u your_user -p your_database --default-character-set=utf8mb4 < your_data_file.sql

import pymysql

# 连接数据库
conn = pymysql.connect(host='your_host', user='your_user', password='your_password', db='your_database', charset='utf8mb4')

# 创建游标
cursor = conn.cursor()

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

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

# 打印结果
for row in results:
    print(row)

# 关闭游标和连接
cursor.close()
conn.close()