[DB-SIG] error1136

Jekabs Andrushaitis jekabs.andrusaitis@tietoenator.com
Mon, 30 Sep 2002 15:18:19 +0200


It is always useful to post on mailing list about your problem!
Usually by the time you finish writing about the problem - you find
the solution yourself. So, faster you ask others, sooner you will
fix it yourself! :)


Jekabs Andrushaitis
Senior system analyst
TietoEnator Financial Solutions
41 Lacplesa Str.
Riga, LV-1011, Latvia
Tel: +371 7286660
Fax: +371 7243000
E-mail: jekabs.andrusaitis@tietoenator.com

> -----Original Message-----
> From: db-sig-admin@python.org
> [mailto:db-sig-admin@python.org]On Behalf
> Of Babu Manjasetty
> Sent: tre=D2diena, 2002. gada 18. septembr=CF 15:24
> To: Magnus Lycka
> Cc: db-sig@python.org
> Subject: Re: [DB-SIG] error1136
>
>
>
> 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	: +49 (0)30 6392 4920
> Fax	: +49 (0)30 6392 4975
> e-mail	: 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??
> >
> > 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?
> >
> >
> > --
> > 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
> >
> >
>
>
> _______________________________________________
> DB-SIG maillist  -  DB-SIG@python.org
> http://mail.python.org/mailman/listinfo/db-sig
>