LOAD DATA INFILE Syntax

http://dev.mysql.com/doc/refman/5.6/en/load-data.html

http://www.linuxidc.com/Linux/2011-06/36947.htm

大的文本保存的数据库格式的导入load data infile 'D:/file.txt' into table user fields terminated by ' # ' lines terminated by '\r\n' (user_id,user_pwd,user_mail) set user_from =1,add_time=1;

LOAD DATA LOCAL INFILE 'd:/t_data.txt' INTO TABLE t FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (user_id,brand,type,date);