摘要:tbl_slope:发生更新的表,checkupdates:更新后插入数据的表CREATEtriggerupdatetbl_slopeAFTERupdate--表示触发器是在激活它的语句之后触发ontbl_slopeforeachrow--mysql固定语法BEGINifEXISTS(SELECT*FROMcheckupdatesAWHEREA.ID=new.UNIFIEDCODELIMIT1)T
tbl_slope:发生更新的表,
checkupdates:更新后插入数据的表
CREATE triggerupdatetbl_slope
AFTER update--表示触发器是在激活它的语句之后触发
ontbl_slope
for each row --mysql固定语法
BEGIN
if EXISTS(SELECT * FROM checkupdates A WHERE A.ID=new.UNIFIEDCODE LIMIT 1)
THEN
update checkupdates set LastTime=NOW() where TableName='TBL_AVALANCHE' and ID=NEW.UNIFIEDCODE;
else
insert into checkupdates VALUES(new.UNIFIEDCODE, 'TBL_AVALANCHE', NOW());
END if;
END