csv文件导入mysql数据库命令

load data local infile 'top-1m-20160501.csv' into table alexa_domains_2 fields terminated by ',' enclosed by '"' lines terminated by '\n' (rank, domain);

如果报错

ERROR 1148: The used command is not allowed with this MySQL version

的话，那么quit之后，执行

mysql -u myuser -p --local-infile somedatabase

进入后就可以了，导数据非常快