cascade - MySQL: Delete PARENTS when CHILDREN row deleted -

cascade - MySQL: Delete PARENTS when CHILDREN row deleted -

let's have parent table: family_member, each having unique id id.

i have family table mother_id, father_id , daughter_id, each pointing family_member row.

when delete family row, i'd db automatically delete 3 family_member parent rows. seems exact opposite of on delete , on update clauses intended do.

create trigger t1 after delete on family each row begin delete family_member id = old.mother_id; delete family_member id = old.fa=ther_id; delete family_member id = old.daughter_id; end

or 1 (you may utilize delimiter name of trigger , table):

create trigger `t1` after delete on `family` each row begin delete family_member id = old.mother_id; delete family_member id = old.fa=ther_id; delete family_member id = old.daughter_id; end

mysql cascade