MySQL Forums
Forum List  »  Newbie

auto-increment
Posted by: Fabian Hess
Date: May 02, 2005 05:17AM

hi,
i've got a table with an auto-increment field in it.
let's say the table's got 100 entries. if i add an new one,
it automatically gets the number 101. so far so good...

if i delete the last one, and add new one, the new one gets
102. now there's a "gap" between 100 and 102.

so, is this a bug or a feature ? :)

Options: ReplyQuote


Subject
Written By
Posted
auto-increment
May 02, 2005 05:17AM
May 02, 2005 05:45AM
May 02, 2005 05:57AM
May 02, 2005 06:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.