配合fields enclosed by '"'使用就可以了
mysql>load data infile '/tmp/tb.txt' into table tbname fields terminated by ',' enclosed by '"' lines terminated by '\r\n';
mysql>load data infile '/tmp/tb.txt' into table tbname fields terminated by ',' enclosed by '"' lines terminated by '\r\n';
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货