Importing CSV data into a table in mySQL database

Question

Ok so I am trying to import data from a CSV file into mySQL database table. The table is called serial_code, however when I try to upload the CSV file I have an error message. I have tried taking the column names out, also adding NULL to the last column EngineSerialCode and I have also viewed the CSV in a text editor and it shows the columns correctly with , comma.

Invalid column count in CSV input on line 1.

Version of phpMyAdmin and mySQL

Database Fields

CSV Fields I want to import

How you are mapping them through, you have 4th column exists in the database table (engine serialcode) — Ven
– Ven, Commented Jun 22, 2017 at 16:02
@BHouse Even when I add that column it displays that error. I am added them through "import" > browse file > Columns separated with: , Comma Columns enclosed with: " Columns escaped with: \ Lines terminated with: auto — Whitena
– Whitena, Commented Jun 23, 2017 at 7:56

Whitena · Accepted Answer · 2017-06-23 09:44:20Z

1

Ok so I found the issue and it was quite frustrating. I had a serial code in my data that had a "," comma instead of a "-". Also I noticed that my CSV file EngineSerialCode was placed in column E and not D as I only have 4 columns in my database. From the image column C is overlapping column D hence my mistake.

answered Jun 23, 2017 at 9:44

Whitena

513 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Importing CSV data into a table in mySQL database

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