MySQL Forums
Forum List  »  Italian

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

Hi,
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


Subject
Views
Written By
Posted
foreign Key
2966
November 09, 2010 07:05AM
1385
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.