[DB-SIG] error1136

[Magnus Lycka]

At 12:32 2002-09-18 +0200, Babu Manjasetty wrote:
>Hi there,
>
>I end up with the error1136 while submitting data to the MySQL
>database. The error is the following :
>
>Error1136: "Column count doesn't match value count at row 1"
>
>What does it mean and how to rectify it??

It sounds to me as the number of columns in the table (or stated
in the insert) doesn't match the number of values you try to
submit.

See below:

mysql> select * from allan
     -> \g
+----+------+
| id | txt  |
+----+------+
|  1 | A    |
|  2 | B    |
+----+------+
2 rows in set (0.02 sec)

mysql> insert into allan values (4)
     -> \g
ERROR 1136: Column count doesn't match value count at row 1

Could you supply an example of the offending code and the relevant
table definition?


--=20
Magnus Lyck=E5, Thinkware AB
=C4lvans v=E4g 99, SE-907 50 UME=C5
tel: 070-582 80 65, fax: 070-612 80 65
http://www.thinkware.se/  mailto:magnus@thinkware.se