autoincrement and renumbering
Hi,
I know that this question has been posted many times before but i have yet to find a good answer.
I have a table to which information will be added and deleted. For each row we have a signed auto_increment number. However, when a row is deleted renumbering continues from the last value. Is it possible to reset the values when a row is deleted?
Or should i be using a better schema?
Thanks
Subject
Written By
Posted
autoincrement and renumbering
March 30, 2006 03:20AM
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.