Mysql trigger 사용 예제

--  트리거처리 : Mysql은 각각 하나에 대한 

오류 코드: 1419

You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

: 에러해결방법 

1. SUPER 권한이 없는 USER

2. log_bin_trust_function_creators 값이 OFF일때 (show global variables like 'log_bin_trust_function_creators';)

  > set global log_bin_trust_function_creators = on;

DELIMITER $$    <----  꼭 한칸을 띄워야되더만...

CREATE TRIGGER TRG_RSV AFTER INSERT ON TB_RSV

FOR EACH ROW

BEGIN    

    

    INSERT INTO TB_HISTORY(RSV_ID,STIME,BEFORE_STATUS,BEFORE_ALERTMSG,BEFORE_REMARK,EDITIP,EDITID)

        VALUES(NEW.RSV_ID,NOW(),NEW.RSTATUS,NEW.ALERT_MSG,NEW.REMARK_,NEW.REG_IP,NEW.REG_ID);

END$$    <----  꼭 붙히고...

DELIMITER ;     <----  꼭 한칸을 띄워야되더만...

DELIMITER $$

CREATE TRIGGER TRG_RSV_UP AFTER UPDATE ON TB_RSV

FOR EACH ROW

BEGIN

    

    INSERT INTO TB_HISTORY(RSV_ID,STIME,BEFORE_STATUS,AFTER_STATUS,BEFORE_ALERTMSG,AFTER_ALERTMSG,BEFORE_REMARK,AFTER_REMARK,EDITIP,EDITID)

        VALUES(NEW.RSV_ID,NOW(),OLD.RSTATUS,NEW.RSTATUS,OLD.ALERT_MSG,NEW.ALERT_MSG,OLD.REMARK_,NEW.REMARK_,OLD.EDIT_IP,NEW.EDIT_ID);

           

END$$

DELIMITER ;