List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:December 28 1999 8:05pm
Subject:Re: Bug? AUTO_INCREMENT not guaranteed unique after DELETE
View as plain text  
>>>>> "CS" == Chris Shenton <cshenton@stripped> writes:

CS> When creating a table with a AUTO_INCREMENT field, it appears to
CS> always set the field's value to one more than the highest *currently*
CS> in the table.  This causes it to *reuse* a value if I delete the row

Which, curiously enough, is *precisely* the definition of
auto_increment according to the MySQL manual.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
Bug? AUTO_INCREMENT not guaranteed unique after DELETEChris Shenton28 Dec
  • Re: Bug? AUTO_INCREMENT not guaranteed unique after DELETEsinisa28 Dec
  • Re: Bug? AUTO_INCREMENT not guaranteed unique after DELETEVivek Khera28 Dec