mysql导入数据，制定特定列的方式

LOAD DATA INFILE error 1064

up vote1down votefavorite

I am running this MySQL command: LOAD DATA LOCAL INFILE 'books.csv' INTO TABLE BOOK (Book_id, @dummy, Title, Publisher_name, @dummy, @dummy) FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n' IGNORE 1 LINES; I am getting an error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n' IGNORE 1 LINES' at line 3 What am I doing wrong here? mysql load-data-infile shareimprove this question edited Jan 11 '14 at 7:56 Eric Leschinski 47.7k25222192 asked Nov 6 '13 at 17:52 pk10 9518

add a comment

2 Answers

activeoldestvotes

up vote4down voteaccepted

http://dev.mysql.com/doc/refman/5.6/en/load-data.html shows the syntax. The clause naming columns goes after the IGNORE clause. LOAD DATA LOCAL INFILE 'books.csv' INTO TABLE BOOK FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (Book_id, @dummy, Title, Publisher_name, @dummy, @dummy); shareimprove this answer