仅为所有行创建触发器 [英] create trigger for selected rows only not for all

问题描述

我将为每一行创建触发器，但是我只想检查选定的行而不是全部
分隔符$$
CREATE TRIGGER参数12
UPDATE ON参数后
每行
开始

插入r21052011
(itemID，paramvalue，date_logged1，Quality，date_logged)值(NEW.itemID，NEW.paramvalue，NEW.date_logged1，NEW.Quality，NEW.date_logged);
END $$

在此先感谢

i will be create the trigger for each row but i want to check only selected rows not all
delimiter $$
CREATE TRIGGER parameter12
AFTER UPDATE ON parameter
FOR EACH ROW
BEGIN

INSERT into r21052011
(itemID,paramvalue,date_logged1,Quality,date_logged)values (NEW.itemID,NEW.paramvalue,NEW.date_logged1,NEW.Quality,NEW.date_logged);
END$$

thanks in advance

推荐答案

CREATE TRIGGER参数12
UPDATE ON参数后
每行
开始

插入r21052011
(itemID，paramvalue，date_logged1，Quality，date_logged)值(NEW.itemID，NEW.paramvalue，NEW.date_logged1，NEW.Quality，NEW.date_logged);
END

CREATE TRIGGER parameter12
AFTER UPDATE ON parameter
FOR EACH ROW
BEGIN

INSERT into r21052011
(itemID,paramvalue,date_logged1,Quality,date_logged)values (NEW.itemID,NEW.paramvalue,NEW.date_logged1,NEW.Quality,NEW.date_logged);
END

预先感谢

thanks in advance

您不能.
但是您可以先进行IF语句检查NEW.*值，或者执行SELECT语句检查值，然后再执行INSERT.

This you cannot.
But you can build an IF statement, checking NEW.* value or do a SELECT statement to check values, before do your INSERT.

这篇关于仅为所有行创建触发器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！