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
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
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