[DB-SIG] error1136

Babu Manjasetty babu@bessy.de
Wed, 18 Sep 2002 15:24:19 +0200 (CEST)


Hi there,

I found the solution to the error 1136. It was my slight mistake in the
python script.

Anyway thanks to those who replied.

Babu

###################################################################

Dr. Babu A. Manjasetty
Protein Structure Factory
C/o Bessy GmbH
Albert-Einstein-Str.15
12489 Berlin Germany
Phone=09: +49 (0)30 6392 4920
Fax=09: +49 (0)30 6392 4975
e-mail=09: babu@bessy.de

##################################################################

On Wed, 18 Sep 2002, Magnus Lycka wrote:

> 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??
>=20
> 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.
>=20
> See below:
>=20
> mysql> select * from allan
>      -> \g
> +----+------+
> | id | txt  |
> +----+------+
> |  1 | A    |
> |  2 | B    |
> +----+------+
> 2 rows in set (0.02 sec)
>=20
> mysql> insert into allan values (4)
>      -> \g
> ERROR 1136: Column count doesn't match value count at row 1
>=20
> Could you supply an example of the offending code and the relevant
> table definition?
>=20
>=20
> --=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
>=20
>=20