MySQL Forums
Forum List  »  Italian

foreign Key
Posted by: Alberto Rossetti
Date: November 09, 2010 07:05AM

I have created a dabatabase with 2 tables:
One has a foreign key on clumn of the other.
I need to modify or delete one record of the first table without that the refernce record of other table is modified or delected.
If i use ON DELETE CASCADE, the reference record is delected, and with NO ACTION mysql give me an error.
Is it possible do this?

Can someone help me?

Options: ReplyQuote

Written By
foreign Key
November 09, 2010 07:05AM
December 27, 2010 06:24PM

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.