Software >> Services >> RDBMS >> MySQL >> Command Line >> What is the syntax of the LOAD DATA command to import a file

LOAD DATA LOCAL INFILE 'c:\home\gmp\public_html\_export\file.csv' INTO TABLE TableName FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\r\n' IGNORE 1 LINES"; sYNTAX: LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name,...)]