将文件导入
load data infile 'C:/Users/86183/Desktop/weather.csv' into table `tb_1` character set gb2312 #注意查看记事本中的脚本是否为gb2312
fields terminated by ','
optionally enclosed by '"'
escaped by '"'
lines terminated by '\r\n'
ignore 1 lines; #如果第一行是字段,忽略第一行
如果在代码部分已经将数据处理成,如图所示的格式
则输入
load data infile 'C:/Users/86183/Desktop/weather.csv' into table `tb_1` character set gb2312 #注意查看记事本中的脚本是否为gb2312
fields terminated by ','
lines terminated by '\r\n'
ignore 1 lines; #如果第一行是字段,忽略第一行
如果仍然出现中文乱码,可以采用如下操作
set character_set_clients=gbk;
set character_set_results=gbk;
set character_set_connection=gbk;