Deleting Data From Multiple Tables
If you have foreign keys to this table, add the option ON DELETE CASCADE.  Then when you delete a row in a parent table all the rows in the child tables that refference that row will be deleted as well.