Cool, no negatives reset the key and it works, thanks, > -----Original Message----- > From: Bobby Oswald > Sent: 05 June 2002 13:50 > To: Fred van Engen; [EMAIL PROTECTED] > Subject: RE: Problem when inserting a record - auto_increment > field gets max integer value instead of next id > > > Removed all the negative values and the same problem still occurs > > > -----Original Message----- > > From: Fred van Engen [mailto:[EMAIL PROTECTED]] > > Sent: 05 June 2002 12:50 > > To: [EMAIL PROTECTED] > > Subject: Re: Problem when inserting a record - auto_increment > > field gets max integer value instead of next id > > > > > > Bobby, > > > > On Wed, Jun 05, 2002 at 12:30:17PM +0200, Bobby Oswald wrote: > > > I have a database with the following table and data: > > > > > > When I add a new record the auto_increment number becomes > > '2147483647' > > > not sure why? Checked the SHOW TABLE STATUS too and this > shows that > > > the next auto_increment number will be '2147483647' > anyone know why? > > > > > > INSERT INTO `ACCategories` VALUES (-1, 'Category not > required', 2); > > > INSERT INTO `ACCategories` VALUES (-2, 'Important Message > for All', > > > 2); > > > > Don't use negative values for auto_increment columns. > > > > > > Regards, > > > > Fred. > > > > > > PS: filter, filter, are you there? (sql, query) > > -- > > Fred van Engen XO Communications B.V. > > email: [EMAIL PROTECTED] Televisieweg 2 > > tel: +31 36 5462400 1322 AC Almere > > fax: +31 36 5462424 The Netherlands > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
