-- 插入触发器
CREATE TRIGGER update_taigger_realtime_di AFTER INSERT ON realtime_di
FOR EACH ROW
BEGIN
DECLARE devId1 INT(11);
DECLARE Name1 varchar(128);
DECLARE s0 varchar(50);
DECLARE s1 varchar(50);
select DevId,`Name`,String0 ,String1 into devId1 ,Name1, s0, s1 from config_di where PtId=NEW.PtId ;
INSERT INTO transfer_data(`PtId`,`DevId`,`Name`,`String0`,`String1`,`Value`,`UpdateTime`)
VALUES(NEW.PtId,devId1,Name1,s0,s1,NEW.Value,NEW.UpdateTime);
END
-- 更新触发器
CREATE TRIGGER update_taigger_realtime_di AFTER UPDATE ON realtime_di
FOR EACH ROW
BEGIN
DECLARE devId1 INT(11);
DECLARE Name1 varchar(128);
DECLARE s0 varchar(50);
DECLARE s1 varchar(50);
IF(OLD.Value<>NEW.Value)
then
select DevId,`Name`,String0 ,String1 into devId1 ,Name1, s0, s1 from config_di where PtId=NEW.PtId ;
INSERT INTO transfer_data(`PtId`,`DevId`,`Name`,`String0`,`String1`,`Value`,`UpdateTime`)
VALUES(NEW.PtId,devId1,Name1,s0,s1,NEW.Value,NEW.UpdateTime);
end if;
END
DROP TRIGGER ins_taigger_realtime_di