在使用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';