java mysql load data_MySQL快速导入文件LOAD DATA INFILE

MySQL导入文本数据LOAD DATA INFILE语法

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'

[REPLACE | IGNORE]

INTO TABLE tbl_name

[PARTITION (partition_name [, partition_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 | ROWS}]

[(col_name_or_user_var

[, col_name_or_user_var] ...)]

[SET col_name={expr | DEFAULT},

[, col_name={expr | DEFAULT}] ...]

** FIELDS参数含义：**

TERMINATED BY ',' //描述字段的分隔符，默认情况下是tab字符(\t)

ENCLOSED BY '"' //描述的是字段的括起字符，比方以双引号括起每一个字段

ESCAPED BY '\' //描述的转义