Import CSV file directly into MySQL

http://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql/

 

我本地导入：

load data local infile 'zipmap.csv' into table zipmap
fields terminated by ','
enclosed by '"'
lines terminated by '/n'
(field_zip_value,field_state_district_value)

 

 

只有两个字段，160万条记录，几秒钟就完成了。

确实很方便。