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,...)]