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.