Re: Swap IDs between two rows
Sorry to revive, but this is a very valid question.
AUTO_INCREMENT NOT NULL insures against duplicate keys, however - one may want to preserve parent key's of other rows on tables.
So instead of updating the pid's of potentially several tables, it makes more sense to swap a new row's id with the old row for archive purposes.
Subject
Written By
Posted
September 20, 2006 07:12AM
September 20, 2006 07:21AM
September 22, 2006 12:49AM
September 22, 2006 06:05AM
Re: Swap IDs between two rows
October 16, 2007 04:38PM
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.