List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:April 23 1999 10:20pm
Subject:Re: AUTO_INCREMENT Limit?
View as plain text  
On Fri, Apr 23, 1999 at 03:09:18PM -0700, Ben Kirkpatrick wrote:
>I must be missing something that gets this to re-use the unused keys.

AUTO_INCREMENT is defined to always return MAX(field)+1; it will
never use up lower key values.

In the future, AUTO_INCREMENT will change so that it is always
increasing.  Once that is done, it will never use any previously-
used value.

The solution for you will be to change the field type to a larger
INT type.  Or, change the application if you don't really need
the auto_increment behaviour.

AUTO_INCREMENT Limit?Ben Kirkpatrick24 Apr
  • Re: AUTO_INCREMENT Limit?Paul DuBois24 Apr
    • I can't shut down mySQL.Daevid Vincent24 Apr
      • Re: I can't shut down mySQL.Paul DuBois24 Apr
    • this listtaubin24 Apr
    • Re: this listFred Read26 Apr
    • Re: I can't shut down mySQL.Daevid Vincent26 Apr
      • Re: I can't shut down mySQL.Michael Widenius27 Apr
    • Re: I can't shut down mySQL.Sasha Pachev27 Apr
  • Re: AUTO_INCREMENT Limit?Thimble Smith24 Apr