mysql 5.7 load data_MySQL 5.5使用LOAD DATA INFILE语句导入数据

相关参数：

local从客户端主机读取文本文件

ignore如果你指定了这个参数，则重复的记录会被跳过

replace如果你指定了这个参数，，则重复的记录会被覆盖掉

IGNORE number LINES导入的时候跳过指定的前几行

例如：LOAD DATA INFILE '/tmp/test.txt' INTO TABLE test IGNORE 1 LINES;

FIELDS TERMINATED BY指定列的分隔符，默认是\t

ENCLOSED BY指定列的包括符，默认是空

例如：load data infile '/tmp/load_starting.txt' into table load_test fields terminated by ',' optionally enclosed by '"' lines starting by 'Neo';

ESCAPED BY指定转义符，默认是\

例如：load data infile '/tmp/ld_t2.csv' into table ld_t2 fields terminated by ',' enclosed by '"' escaped by '|';

LINES TERMINATED BY指定换行符，默认是\n

例如：load data infile '/tmp/ld_t5.csv' into table ld_t5 fields terminated by ',' enclosed by '"' escaped by '|'