256 Kilobytes

Answers in Databases | By Some Guy


356 views, 0 RAMs, and 1 comment

Tags: PHP, MySQL, Database, Errors, Programming

Profile Photo - Some GuySome GuyBasic Subscriber

I have been using MySQL to organize some data for a database and I have run into a puzzling error message. Can someone tell me what "Column count doesn't match value count at row 1" means and how I can fix it?

Download more RAM. 🐏 ⨉ 0Posted by Some Guy 2 years ago 🕓 Posted at 16 December, 2018 09:40 AM PST

This is a debug account.

Profile Photo - August R. GarciaAugust R. GarciaLARPing as a Sysadmi...Portland, ORSite Owner

This error can occur if you are missing If your insert statement does not specify the number of columns correct. Example of incorrect statement:

  • INSERT INTO users (name, email) VALUES ("John", "john@email.com", "555 555-5555");
    • Gives the error "ERROR 1136 (21S01): Column count doesn't match value count at row 1"

Instead of this:

  • INSERT INTO users (name, email, phone) VALUES ("John", "john@email.com", "555 555-5555");
    • Works correctly.

Download more RAM. 🐏 ⨉ 0Posted by August R. Garcia 2 years ago 🕓 Posted at 20 December, 2018 01:18 AM PST

Sir, I can do you a nice SEO.

Post a New Comment

Do you like having a good time?

Register an Account

You can also login to an existing account or reset your password. All use of this site is subject to the terms of service and privacy policy.

Read Quality Articles

Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.

View Articles →

Argue with People on the Internet

Use your account to explain why people are wrong on the Internet forum.

View Forum →

Vandalize the Wiki

Or don't. I'm not your dad.

View Wiki →

Ask and/or Answer Questions

If someone asks a terrible question, post a LMGTFY link.

View Answers →

Make Some Money

Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.

Register an Account

Answers— Read More

Find more related content below!