命令:
mysql -h localhost -uroot -proot test -e "load data local infile '/Users/xiaomai/workspace/python/pachong/de3.txt' into table dz_ershoufang character set 'utf8' fields terminated by '\t'"
首先查看一下数据库的编码
SHOW VARIABLES LIKE "%CHAR%";
然后设置一下它们的编码为utf8
SET NAMES utf8;
再重新查看一下数据库的编码
SHOW VARIABLES LIKE "%CHAR%";
如果还有部分编码未改变,可以进行单个设置
SET character_set_database = utf8;
SET character_set_server = utf8;
再次重新查看一下数据库的编码
SHOW VARIABLES LIKE "%CHAR%";