用于插入和更新的MySQL Fire触发器 [英] MySQL Fire Trigger for both Insert and Update

问题描述

是否可以针对表的插入和更新事件触发mysql触发器?

Is it possible to fire a mysql trigger for both the insert and update events of a table?

我知道我可以做以下事情

I know I can do the following

CREATE TRIGGER my_trigger
    AFTER INSERT ON `table`
    FOR EACH ROW
BEGIN
.....
END //

CREATE TRIGGER my_trigger
    AFTER UPDATE ON `table`
    FOR EACH ROW
BEGIN
.....
END //

但是我该怎么办

CREATE TRIGGER my_trigger
    AFTER INSERT ON `table` AND
    AFTER UPDATE ON `table`
    FOR EACH ROW
BEGIN
.....

是否可以，或者我必须使用2个触发器?两者的代码相同，我不想重复.

Is it possible, or do I have to use 2 triggers? The code is the same for both and I don't want to repeat it.

推荐答案

您必须创建两个触发器，但是您可以将通用代码移动到过程中并让它们都调用该过程.

You have to create two triggers, but you can move the common code into a procedure and have them both call the procedure.

这篇关于用于插入和更新的MySQL Fire触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！