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);