Syntax error when load csv file into mysql

Question

Compiler says the syntax error is near "FIELDS TERMINATED....."

LOAD DATA LOCAL INFILE '/Data/books.csv' 
INTO TABLE Book 
IGNORE 1 LINES
(@col1,@col2,@dummy,@dummy,@dummy,@dummy,@dummy,@dummy) 
set Book_id=@col1,Title=@col2
FIELDS TERMINATED BY '\t' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

post a sample of you books.csv

Enkode
– Enkode

2015-10-02 03:24:00 +00:00
Commented Oct 2, 2015 at 3:24 — Enkode
– Enkode, Commented Oct 2, 2015 at 3:24
Thank you, while David has solved the problem ; )

Czon
– Czon

2015-10-03 21:41:16 +00:00
Commented Oct 3, 2015 at 21:41 — Czon
– Czon, Commented Oct 3, 2015 at 21:41

David Soussan · Accepted Answer · 2015-10-02 02:49:36Z

3

That is because you have the column list and set before your fields clause. Mysql will have used the defaults when no fields|lines was encountered then processed the col list and then thrown an error when it encountered the fields clause. Try this

LOAD DATA LOCAL INFILE '/Data/books.csv' 
INTO TABLE Book 
FIELDS TERMINATED BY '\t' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n' 
IGNORE 1 LINES
(@col1,@col2,@dummy,@dummy,@dummy,@dummy,@dummy,@dummy) 
set Book_id=@col1,Title=@col2

answered Oct 2, 2015 at 2:49

David Soussan

2,7261 gold badge18 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error when load csv file into mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related