mysql-load data local infile

在使用load data local infile从文本文件中加载数据到MySQL表中，若不显示指明fields段或enclosed段和line段，默认以制表符‘\t’，即一个tabj键为分隔符

即

如果你不指定一个FIELDS子句，缺省值与如果你这样写的相同：

FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\'

如果你不指定一个LINES子句，缺省值与如果你这样写的相同：

LINES TERMINATED BY '\n' 

若文本中内容格式为 "dfs","fds","dd"

则mysql> LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
           FIELDS TERMINATED BY ',' ENCLOSED BY '"'
           LINES TERMINATED BY '\n';