Thursday, April 11, 2013

What's the MySQL syntax for adding a foreign key?

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.

No comments:

Post a Comment

About Me

My photo
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,, 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.