是的你可以。您可以创建一个过程并在触发器中调用它。程序示例:
DELIMITER //CREATE PROCEDURE delete(in table VARCHAr(300), in db VARCHAr(300), in id INT)BEGINset @query0 = CONCAt('DELETE FROM ', new_db, '.', tabela, ' WHERe id=',id);PREPARE select_query0 FROM @query0;EXECUTE select_query0;DEALLOCATE PREPARE select_query0;END; //DELIMITER ;然后创建触发器:
CREATE TRIGGER del_trigger BEFORE DELETE ON table FOR EACH ROW BEGIN CALL delete(db, table, OLD.id); END;



