Re: AUTO_INCREMENT Limit?

[Thimble Smith]

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.

Tim