Essential Books

LOAD DATA INFILE

suggest change

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,…]
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

LOAD DATA INFILE:
* LOAD DATA INFILE
* using LOAD DATA INFILE to load large amount of data to database
* Load data with duplicates
* Import a CSV file into a table
* import export
Table Of Contents