PhpMyAdmin Invalid Column Count in CSV input on line 1

PhpMyAdmin Invalid Column Count in CSV input on line 1

If you are receiving this error while tryng to import a CSV file, make sure that the number of columns in your CSV matches that of your existing database table.


I had an existing table with 10 columns, the first column was `id` an auto-increment field. I omitted this from my CSV file presuming it would be auto geberated but it's not.


number of columns in CSV = number of columns in database table

Airbnb £25 Discount Code
Google In-Page Analytics Not Working
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
February 27, 2020

Captcha Image

Latest Comments

Guest - Susan Hermiston Virtual Hosts
October 7, 2015
Wow 747 just blew me away. Sorry not a tech person at all!! But I still love you!! Rock on!!?
Guest - Johmny Invisible Mouse Cursor Ubuntu & Synergy
September 2, 2015
Glad I was ble to help!
Guest - Kristian Falk Invisible Mouse Cursor Ubuntu & Synergy
September 1, 2015
Thank you for this! Had the exact same problem. I almost went crazy.