I have a MySql DB.
I have a table - recipes. Also have 2 tables -ingredients and instructions. both have for each entry - a foreign key to the related recipe.
I want that when I delete an entry from the recipes table - to automaticly delete the related ingredients entries and instruction entries.