1. txt大数据文件导入: LOAD DATA

格式：
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
 [REPLACE | IGNORE]
 INTO TABLE tbl_name
 [CHARACTER SET charset_name]
 [{FIELDS | COLUMNS}
   [TERMINATED BY 'string']
   [[OPTIONALLY] ENCLOSED BY 'char']
   [ESCAPED BY 'char']
 ]
 [LINES
   [STARTING BY 'string']
   [TERMINATED BY 'string']
 ]
 [IGNORE number LINES]
 [(col_name_or_user_var,...)]
 [SET col_name = expr,...]


例：
mysql> LOAD DATA INFILE '/home/apache/htdocs/crms/test.txt' INTO TABLE tablename CHARACTER SET latin1 FIELDS TERMINATED BY ',' LINES TERMINATED BY ' ' (id,field1,field3,field5,field2);

说明：
CHARACTER SET latin1      导入表字符集
FIELDS TERMINATED BY ','    是指字段间以逗号分隔；

LINES TERMINATED BY ' '  window环境行尾
LINES TERMINATED BY ' '    linux环境行尾

补充：
optionally ENCLOSED BY '”'  表示字符型日期型的字段会加””
ENCLOSED BY '”'             表示所有的字段都会加”

当要替换或忽视原来表中相同的数据时，可以用replace 或者ignore：
mysql> load data infile '/tmp/test.txt' replace into table tablename fields terminated by ' ';