Cannot import csv into mysql database using phpmyadmin wizard

Question

I am trying to import a csv file into my mysql database using phpmyadmin but keep getting errors.

Here is how the csv looks:

enter image description here

Then I import like this: enter image description here

And get the error: "Invalid parameter for CSV import: Fields enclosed by". I have tried to put the columns in quotes " or put a semicolon after each column, but keep getting errors.

I worked through the same issues a few months ago. Ultimately got everything to work...then I found MySQL Workbench - changed my life. Easy, fast, slick and...free. — TimSPQR
– TimSPQR, Commented Oct 26, 2013 at 3:17

Isaac Bennetch · Accepted Answer · 2013-10-26 03:03:48Z

1

Yeah, you have an extra field in there. For instance, with your example line of:

itemId,date,description,amount
,1,2/13/2013,Fabrics,44

the date maps to "description" because of the leading comma, which basically gives an empty (or null, depending on how the import is handled) value to itemId, which doesn't seem to be what you want. Where'd that extra comma come from -- was this an export from some program?

Also, in this case you don't have anything enclosing the fields so you should just be able to leave that value empty, which seems to have worked for you once you got the column count corrected.

answered Oct 26, 2013 at 3:03

Isaac Bennetch

12.5k2 gold badges37 silver badges46 bronze badges

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

Comments

samyb8 · Accepted Answer · 2013-10-25 14:18:16Z

0

I had to remove the first line of the csv (containing the column names) and that solved the issue. Everything got imported properly.

Note, the date field needed reformatting to match SQL's date format yyyy-mm-dd.

answered Oct 25, 2013 at 14:18

samyb8

2,59810 gold badges42 silver badges70 bronze badges

Collectives™ on Stack Overflow

Cannot import csv into mysql database using phpmyadmin wizard

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related