txt导入mysql有乱码怎么解决

-- 查看当前数据库的字符集
SHOW VARIABLES LIKE 'character_set_%';

-- 设置数据库的字符集为UTF-8
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

LOAD DATA INFILE 'path_to_your_file.txt'
INTO TABLE your_table_name
CHARACTER SET utf8mb4
FIELDS TERMINATED BY ',' -- 根据实际情况设置字段分隔符
ENCLOSED BY '"' -- 根据实际情况设置字段包围符
LINES TERMINATED BY '\n' -- 根据实际情况设置行分隔符;

id,name,age
1,张三,25
2,李四,30

-- 设置数据库字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 导入数据
LOAD DATA INFILE 'data.txt'
INTO TABLE your_table_name
CHARACTER SET utf8mb4
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';