1136: Column count doesn't match value count at row 1

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bugthefixer
Forum Contributor
Posts: 118
Joined: Mon Mar 22, 2004 2:35 am

1136: Column count doesn't match value count at row 1

Post by bugthefixer »

i m getting this error i dont know y...although theres no php code on line 1 and theres no coloumn with name count..
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

It means you've done something like:
INSERT INTO foo (one,two,three) VALUES ('oneval','twoval')
i.e the column count ^^ doesn't match the value count ^^ (3 columns, 2 values)
Post Reply