LOAD DATA LOCAL; How to skip the first line?

Question

I am trying to upload a CSV file to my MySQL database, but I would skip the first line.

I am a fact. It contains the name of my columns and no interesting data.

Here is the query I'm using:

LOAD DATA LOCAL INFILE '/myfile.csv' INTO TABLE tableName FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' (column,column,column); 

Answer 1

 LOAD DATA INFILE '/tmp/test.txt' INTO TABLE test IGNORE 1 LINES; 

( link )

Answer 2

For the curious, IGNORE N LINES should be after the qualifier separators:

 LOAD DATA LOCAL INFILE '/myfile.csv' INTO TABLE tableName FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 1 LINES (column,column,column); 

Answer 3

IGNORE 1 LINES throws an error: SQL * Loader-350: Syntax error on line 7. Expected "(", found to "ignore".

How do I solve this?