Created
August 4, 2014 15:44
-
-
Save souparno/842bf4bf171c34ed1402 to your computer and use it in GitHub Desktop.
mysql relation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ALTER TABLE user | |
| ADD CONSTRAINT fk_Pin | |
| FOREIGN KEY (pin_no) | |
| REFERENCES pin(pin_no) | |
| ON DELETE CASCADE | |
| ON UPDATE CASCADE |
ALTER TABLE Orders
DROP FOREIGN KEY fk_PerOrders
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
ALTER TABLE Orders
ADD FOREIGN KEY (P_Id)
REFERENCES Persons(P_Id)