Re: AUTO_INCREMENT not guaranteed unique after DELETE

[Paul DuBois]

At 8:07 PM +0100 1999-12-28, Matthias Urlichs wrote:
>Hi,
>
>Paul DuBois:
>>
>>  As of 3.23, if you use the MyISAM table storage type, the sequence
>>  will be monotonic without values being reused.  (The sequence will,
>>  however, still restart at zero if you empty the table completely.)
>>
>What happens if the range is too small?

Range of what?  The underlying column type?  Same thing as before,
you'll get a duplicate key error.  Choose a type that's "big enough". :-)

-- 
Paul DuBois, paul@stripped