MySQL LOAD DATA LOCAL，如何跳过第一行？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1618355/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
LOAD DATA LOCAL, How do I skip the first line?
提问by Roch
I'm trying to Load a CSV file into my MySQL database, But I would like to skip the first line.
我正在尝试将 CSV 文件加载到我的 MySQL 数据库中，但我想跳过第一行。
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);
回答by Chad Geary
For those curious, IGNORE N LINES should be after the separator qualifiers:
对于那些好奇的人，IGNORE N LINES 应该在分隔符限定符之后：
LOAD DATA LOCAL INFILE '/myfile.csv'
INTO TABLE tableName
FIELDS TERMINATED BY ','
ENCLOSED BY '\"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(column,column,column);
回答by bharat bhagat
Try this:
尝试这个：
IGNORE N LINES
LOAD DATA INFILE "/path/to/file.csv"
INTO TABLE MYTABLE
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;
