LOAD DATA LOCAL, How do I skip the first line?
For those curious, IGNORE N LINES should be after the separator qualifiers:
LOAD DATA LOCAL INFILE '/myfile.csv' INTO TABLE tableNameFIELDS TERMINATED BY ','ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 1 LINES(column,column,column);
Try this:
IGNORE N LINESLOAD DATA INFILE "/path/to/file.csv"INTO TABLE MYTABLE COLUMNS TERMINATED BY ','OPTIONALLY ENCLOSED BY '"'LINES TERMINATED BY '\n'IGNORE 1 LINES;