我用以下语句从csv中导入数据,数据到是都导入了,但是中文的数据出现问题
LOAD DATA INFILE 'd:\\contry.csv' REPLACE INTO TABLE `bas_district` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
LOAD DATA INFILE 'd:\\contry.csv' REPLACE INTO TABLE `bas_district` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货