ALTER TABLE `your_referencing_table` ADD CONSTRAINT `your_new_fk_name` FOREIGN KEY (`your_referencing_table_field`) REFERENCES `your_foreign_table` (`your_foreign_table_field`) ON DELETE CASCADE ON UPDATE CASCADE;Note that `your_referencing_table_field` must be indexed.
Thursday, April 11, 2013
What's the MySQL syntax for adding a foreign key?
Subscribe to:
Post Comments (Atom)
About Me
- John Erck
- I code. I figured I should start a blog that keeps track of the many questions and answers that are asked and answered along the way. The name of my blog is "One Q, One A". The name describes the format. When searching for an answer to a problem, I typically have to visit more than one site to get enough information to solve the issue at hand. I always end up on stackoverflow.com, quora.com, random blogs, etc before the answer is obtained. In my blog, each post will consist of one question and one answer. All the noise encountered along the way will be omitted.
No comments:
Post a Comment