MySQL Invalid column count in CSV input on line 1

Question

Ok row 1 consists of the following names in my CSV file:

id
username
password
email
fname
lname
organization
add_1
add_2
city
state
zip
country
phone
fax
group_id

In my MySQL table, it's as followed:

id  int(11)
username    varchar(35)
password    varchar(60)
email   varchar(50)
fname   varchar(25)
lname   varchar(25)
organization    varchar(50)
add_1   varchar(50)
add_2   varchar(50)
city    varchar(45)
state   varchar(2)
zip varchar(6)
country varchar(25)
phone   varchar(11)
fax varchar(11)
group_id    tinyint(3)

I don't get why it's throwing this error... there are 16 columns in each one. They are named exactly the same..

I even tried deleting the ID column and still no luck.

My CSV file:

username,password,email,fname,lname,organization,add_1,add_2,city,state,zip,country,phone,fax,group_id
apewraps,BxKgp9IykPvaPuN07Rowbv9CPhgO73F1TWZEDtJjN,[email protected],First Name,Last Name,Organization,Address,City,OH,40394,US,3049303939,1
bp-graphics,8C3EwVs12AhauYKAHrCfbXc79ENJYf7tw9UiFzvN6,[email protected],First Name,Last Name,Organization,Address,City,OH,40394,US,3049303939,1

I even tried it with the ID column:

id,username,password,email,fname,lname,organization,add_1,add_2,city,state,zip,country,phone,fax,group_id
1,apewraps,BxKgp9IykPvaPuN07Rowbv9CPhgO73F1TWZEDtJjN,[email protected],First Name,Last Name,Organization,AddressCity,OH,40394,US,30493039391
2,bp-graphics,8C3EwVs12AhauYKAHrCfbXc79ENJYf7tw9UiFzvN6,[email protected],First Name,Last Name,Organization,AddressCity,OH,40394,US,30493039391

Still nothing. I was looking at this thread: Problems importing a CSV file

But those trailing commas and id column didn't help. I even kept the trailing commas at the end and it still does nothing.

Thanks for any help.

Peanut · Accepted Answer · 2013-12-11 18:46:58Z

4

I was specifying my end of my columns odd.

It had this by default:

Lines terminated with: auto

When it should have been:

Lines terminated with: \n

And make sure your columns are terminated by ,. Sometimes it has ; by default.

answered Dec 11, 2013 at 18:46

Peanut

3,3257 gold badges30 silver badges47 bronze badges

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

Comments

Yurii · Accepted Answer · 2014-09-29 06:17:39Z

2

One of the ways to do it (kinda hacky) is to delete your existing table. Go to the database and select import, then import the .csv file with the necessary settings and Voila it gets imported with a new table being created with your existing columns, you might have to change a few column names and delete a few rows from the end.

edited Sep 29, 2014 at 6:17

Yurii

4,9217 gold badges38 silver badges45 bronze badges

answered Sep 29, 2014 at 4:42

Saras Arya

3,1729 gold badges44 silver badges74 bronze badges

2 Comments

Bhushan Kawadkar Over a year ago

please provide some code examples to the answer posted, this will help others.

Saras Arya Over a year ago

If you have wampp/xampp installed you don't need to write code for it phpmyadmin will do it for ya.

Collectives™ on Stack Overflow

MySQL Invalid column count in CSV input on line 1

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related