Re: insert: auto increment field

[Mike Mapsnac]

I use both metods and they works  But when I make another insert I receive a 
message
ERROR: 1062 Duplicate entry '2147483647' for key 1.

Why id (primaty , and auto_increment) start from 2147483647 and not from 0 
or 1

Thanks


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]
_________________________________________________________________
Get reliable dial-up Internet access now with our limited-time introductory 
offer.  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]