LOAD DATA LOCAL, How do I skip the first line?

Question

I'm trying to Load a CSV file into my MySQL database, But I would like to skip the first line.

I 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; 

(reference)