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
