LOAD DATA INFILE

Syntax

1. LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE ‘file_name’
2. INTO TABLE tbl_name
3. [CHARACTER SET charset]
4. [{FIELDS | COLUMNS}

[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']]

1. [LINES

[STARTING BY 'string']
[TERMINATED BY 'string']
]

1. [IGNORE number {LINES | ROWS}]
2. [(col_name_or_user_var,…)]
3. [SET col_name = expr,…]