MySQL Forums
Forum List  »  Newbie

Re: Auto_Increment
Posted by: Peter Brawley
Date: April 03, 2018 09:12AM

Did you try it?

"Lost" auto_increment values aren't re-used. To put it another way, auto_increment is not to be relied upon to provide a gapless sequence. If you need that, write your own eg by creating an populating a sequence table that marks each row use in turn.

Options: ReplyQuote


Subject
Written By
Posted
April 03, 2018 08:04AM
Re: Auto_Increment
April 03, 2018 09:12AM
April 04, 2018 05:12AM


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.