Re: issues with foreign key constraint ERROR 1005

[Zach Ellis]

Hello Jon

This might be a dumb question that I have.

for the formatting of code does that go with all links? or should i use a [LINK] tag for links

ex
[LINK] https://stackoverflow.com/questions/12994919/errno-121-duplicate-key-on-write-or-update


is this how it should be used.

ALTER TABLE `TCTSandpit`.`tbl_Emp_Expences`
ADD CONSTRAINT `Emp_ID`
FOREIGN KEY (`Emp_ID`)
REFERENCES `TCTSandpit`.`tbl_Emp_Details` (`Emp_ID`)
ON DELETE CASCADE
ON UPDATE CASCADE; 

or should we have the code in the brackets

[CODE
ALTER TABLE `TCTSandpit`.`tbl_Emp_Expences`
ADD CONSTRAINT `Emp_ID`
FOREIGN KEY (`Emp_ID`)
REFERENCES `TCTSandpit`.`tbl_Emp_Details` (`Emp_ID`)
ON DELETE CASCADE
ON UPDATE CASCADE; 
]

or should there be a 
 tag at the start of the code and one at the end.

ALTER TABLE `TCTSandpit`.`tbl_Emp_Expences`
ADD CONSTRAINT `Emp_ID`
FOREIGN KEY (`Emp_ID`)
REFERENCES `TCTSandpit`.`tbl_Emp_Details` (`Emp_ID`)
ON DELETE CASCADE
ON UPDATE CASCADE;

Thank you for your time
Zach Ellis