Re: Foreign key column with possible copy of self's key value?
Posted by: Rick James
Date: March 25, 2011 07:13PM

Personally, I don't bother with FOREIGN KEYs.

What language are you using? See LastInsertId (or something like that) in your language. It will provide the ID provided for the AUTO_INCREMENT from the last statement. Then you can provide that as ParentId in the next statement.

Options: ReplyQuote


Subject
Written By
Posted
Re: Foreign key column with possible copy of self's key value?
March 25, 2011 07:13PM


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.