LOAD DATA LOCAL INFILE 'c:\\1.csv' into table xlsinventory character set gbk fiELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES"
用这段代码时候,如果1行内有,的话,就会有问题,请问大家是怎么解决的?
...全文
1349打赏收藏
Load Data问题
LOAD DATA LOCAL INFILE 'c:\\1.csv' into table xlsinventory character set gbk fiELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES" 用这段代码时候,如果1行内有,的话,就会有问题,请问大家是怎么解决的?