트리거 공부중인데 BEFORE와 AFTER 같이 사용가능 한가요?
같이 사용가능하면 어떻게 해야되나요??
DELIMITER $$
CREATE
TRIGGER aa
BEFORE INSERT
ON aa
FOR EACH ROW BEGIN
INSERT INTO bb(aa,bb) VALUES(NOW(),"aa1");
UPDATE bb SET bb=bb+1 WHERE aa='aa';
AFTER INSERT
ON aa
FOR EACH ROW BEGIN
INSERT INTO bb(aa,bb) VALUES(NOW(),new.bb);
UPDATE bb SET bb=bb+1 WHERE aa='aa';
DELETE FROM bb WHERE bb='aa';
END$$
DELIMITER ;
오라클 11G 부터 compound trigger 사용이 가능합니다.
아!! mySQL 이군요...
CREATE OR REPLACE TRIGGER tri_compound_test FOR INSERT OR UPDATE OR DELETE ON test COMPOUND TRIGGER BEFORE STATEMENT IS BEGIN NULL; END; BEFORE EACH ROW IS BEGIN NULL; END; AFTER EACH ROW IS BEGIN NULL; END; AFTER STATEMENT IS BEGIN NULL; END; END; /