MySQL触发器简单示例

MySQL触发器在某些应用场景中还是很有必要的，以下就是一个简单的MySQL触发器示例：

DROP TRIGGER IF EXISTS `checktrigger`;
CREATE TRIGGER `sq_hostweb`.`checktrigger` AFTER UPDATE ON `ws_device_runing` FOR EACH ROW
BEGIN
	if(new.updtime!=old.updtime) then
		insert into ws_device_checking(id,partid,devid,itemid,runstate,checked,addtime) values(new.runid,new.partid,new.devid,new.itemid,new.runstate,0,new.updtime);
	end if;
END