mysql 怎么导入特殊符号

-- 检查数据库字符集
SHOW CREATE DATABASE your_database_name;

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

-- 检查表字符集
SHOW CREATE TABLE your_table_name;

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

-- 使用mysqldump导入数据时指定字符集
mysqldump -u username -p --default-character-set=utf8mb4 your_database_name > dump.sql
mysql -u username -p your_database_name < dump.sql

-- 设置客户端连接字符集
SET NAMES utf8mb4;

mysql -u username -p your_database_name --default-character-set=utf8mb4 -e "LOAD DATA INFILE 'data.csv' INTO TABLE your_table_name FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n';"