LOAD DATA INFILE

Download mysql eBook

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']]
  5. [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ]
  6. [IGNORE number {LINES | ROWS}]
  7. [(col_name_or_user_var,...)]
  8. [SET col_name = expr,...]

Related Examples

Stats

261 Contributors: 7
Sunday, November 13, 2016
Licensed under: CC-BY-SA

Not affiliated with Stack Overflow
Rip Tutorial: info@zzzprojects.com

Download eBook