triggers

delimiter //
create trigger buganaderia before update on ganaderia for each row
begin
update from toros where id_ganaderia=OLD.id_ganaderia;
end //


delimiter //
create trigger bdganaderia before delete on ganaderia for each row
begin
delete from toros where id_ganaderia=OLD.id_ganaderia;
end //