笔记：触发器例子模板

CREATE TRIGGER TRG_VIDEOCOURSE  BEFORE UPDATE ON FH_VIDEOCOURSE FOR EACH ROW

BEGIN

       IFNEW.STATUS = '1' -- 直播开始

              THENUPDATE FH_FITCOURSE SET STATUS = NEW.STATUS WHERE ID = NEW.FITCOURSEID;

       ELSEIFNEW.STATUS = '2' -- 直播结束

              THEN

              BEGIN

                     UPDATEFH_FITCOURSE SET STATUS = '0' WHERE ID = NEW.FITCOURSEID;

                     UPDATEFH_FITAPPOINT SET INVALID = '1', STATUS= '2' WHERE ITEMID = NEW.FITCOURSEID ANDAPPOINTTIME < NOW();

                     INSERTINTO FH_VIDEOCOURSEHIS(VIDEOID, CUSTOMERID, FITCOURSEID, FEIHAID, STATUS,CREATE_BY, CREATE_DATE, UPDATE_BY, UPDATE_DATE, REMARKS, DEL_FLAG)

                                                               SELECTNEW.VIDEOID, OLD.CUSTOMERID, OLD.FITCOURSEID, OLD.FEIHAID, '2', OLD.CREATE_BY,NOW(), OLD.UPDATE_BY, NOW(), OLD.REMARKS, '0';

                     SETNEW.STATUS = '0';

              END;

       ENDIF;

END