MySQL error loading data file

Question

i am trying to execute this query unfortunately i am getting an error ,can anyone tell why this error appear,where i went wrong

my query:

    LOAD DATA INFILE '/wamp/www/var/Book1.csv' INTO TABLE contact
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES
(
@dummy , @dummy , column1, @dummy , column3, column2, @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , column4, @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy
)  ;

Error:

#1064 - 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 ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES' at line 4

Jens · Accepted Answer · 2014-06-28 07:09:23Z

1

You have to change the order of fields... and the column names:

LOAD DATA INFILE '/wamp/www/var/Book1.csv' INTO TABLE contact
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES
(
@dummy , @dummy , name, @dummy , nationality, mobile1, @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , twon, @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy
)  ;

answered Jun 28, 2014 at 7:09

Jens

69.6k15 gold badges107 silver badges133 bronze badges

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

7 Comments

Xavi Over a year ago

thanks for you answer it worked but it insert the cvs data into wrong coloumns in mysql ,example in name its entering the country data in mysql also name,nationality,mobile1 is not inserting into mysql can you tell me why also how to do it

Xavi Over a year ago

can you saw my cvs structure

Jens Over a year ago

@Xavi ` @dummy , @dummy , column1, @dummy , column3, column2, @dummy` ... and so on?

Xavi Over a year ago

so i should write column1 instead of name?

Jens Over a year ago

@Xavi Yes. That's what i mean

|

Collectives™ on Stack Overflow

MySQL error loading data file

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related