Cascade on updates and deletes
FOREIGN KEY constraints (and the ON UPDATE ... CASCADE and ON DELETE ... CASCADE syntax that goes with them) are currently only available for InnoDB tables. While adding FOREIGN KEY constraints to MyISAM tables is on the development roadmap, I would not expect them in the near future. In short, InnoDB is your only choice at the moment.
Dig Deeper on Linux servers
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Data Center experts
View all Data Center questions and answers
Start the conversation
0 comments