LOAD DATA LOCAL INFILE '/home/xyzqing/top-1m.csv' INTO TABLE `alexa_top` FIELDS TERMINATED BY ',';
顺带一句,linux下more *.csv 可以看到字段分隔符。
LOAD DATA LOCAL INFILE '/home/xyzqing/top-1m.csv' INTO TABLE `alexa_top` FIELDS TERMINATED BY ',';
顺带一句,linux下more *.csv 可以看到字段分隔符。