List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 28 1999 7:13pm
Subject:Re: AUTO_INCREMENT not guaranteed unique after DELETE
View as plain text  
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
Thread
AUTO_INCREMENT not guaranteed unique after DELETEchris28 Dec
  • Re: AUTO_INCREMENT not guaranteed unique after DELETEJames Lyon28 Dec
  • Re: AUTO_INCREMENT not guaranteed unique after DELETEChris Shenton28 Dec
  • Re: AUTO_INCREMENT not guaranteed unique after DELETEJames Lyon28 Dec
  • Re: AUTO_INCREMENT not guaranteed unique after DELETEPaul DuBois28 Dec
    • Re: AUTO_INCREMENT not guaranteed unique after DELETEMatthias Urlichs28 Dec
      • Re: AUTO_INCREMENT not guaranteed unique after DELETEPaul DuBois28 Dec
  • Re: AUTO_INCREMENT not guaranteed unique after DELETEChris Shenton28 Dec
    • Re: AUTO_INCREMENT not guaranteed unique after DELETEPeter J. Schoenster29 Dec
      • Re: AUTO_INCREMENT not guaranteed unique after DELETEPaul DuBois29 Dec
      • Re: AUTO_INCREMENT not guaranteed unique after DELETEhypnos29 Dec
        • Re: AUTO_INCREMENT not guaranteed unique after DELETEKen Scott29 Dec