Problem when inserting a record - auto_increment field gets max integer value instead of next id

2002-06-05 Thread Bobby Oswald
Hi, 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? Running MySQL 3.23.41

RE: Problem when inserting a record - auto_increment field gets max integer value instead of next id

2002-06-05 Thread Bobby Oswald
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

RE: Problem when inserting a record - auto_increment field gets max integer value instead of next id

2002-06-05 Thread Bobby Oswald
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