mysq load csv file

LOAD DATA LOCAL INFILE '/home/xyzqing/top-1m.csv' INTO TABLE `alexa_top` FIELDS TERMINATED BY ',';

 

顺带一句，linux下more *.csv 可以看到字段分隔符。