drop trigger if exists sorder_before_delete; DELIMITER // create trigger sorder_before_delete after delete on dbr_sorder for each row begin delete from dbr_sorder_bd where sorder_id = old.id; delete from dbr_sales where sorder_id = old.id; END// DELIMITER ;