MySQL, 5th Edition

LOAD DATA

Click here to view code image

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'   [IGNORE | REPLACE]   INTO TABLE tbl_name   [PARTITION (partition_name [, partition_name] ...)]   [CHARACTER SET charset]   [field_options] [line_options]   [IGNORE n {LINES | ROWS}]   [(col_or_user_var_name, ...)]   [SET col_name = expr [, col_name = expr] ...]

LOAD DATA reads input records from the file file_name and loads them in bulk into the table tbl_name. This is faster than using a set of INSERT statements. As of MySQL 5.6.2, LOAD DATA supports a PARTITION clause for partitioned tables to indicate the partitions or subpartitions into which to insert rows. In this case, an error occurs if a row would not be inserted in any named partition. ...