(You forgot to post this to the list.)
Check to make sure you have the ID field set as autoincrement. By the
way, duplicate entry is not the same thing as column count not matching.
Also check to see if you have any other fields set as unique.
On Sun, 2004-01-04 at 09:12, Mike Mapsnac wrote:
> I just tried.. Same problem with
> "Duplicate Entry"
>
>
> >From: Donald Henson <[EMAIL PROTECTED]>
> >To: MySQL List <[EMAIL PROTECTED]>
> >Subject: Re: insert: auto increment field
> >Date: Sun, 04 Jan 2004 08:44:56 -0700
> >
> >On Sun, 2004-01-04 at 08:09, Mike Mapsnac wrote:
> > > I have table with 7 fields. First field is id (auto increment). As I
> > > understand the value should start from 0 and next value will auto
> > > increment.
> > >
> > > And I shouldn't add insert the value. So the insert
> > > statemens below gives me an error. ERROR 1136:Column count doesn't match
> > > value count at row 1
> > >
> > > insert into product values('456789','t1', 'new', 2, 2, 10);
> >
> >Try using NULL for the id field, thusly:
> >
> >insert into product values (NULL,'456789','t1','new',2,2,10);
> >
> >I didn't actually try this but it should work.
> >
> >Don Henson
> >
> >
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
> _________________________________________________________________
> Take advantage of our limited-time introductory offer for dial-up Internet
> access. http://join.msn.com/?page=dept/dialup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
