CREATE OR REPLACE TRIGGER TRIGGERname AFTER DELETE OR INSERT OR UPDATE ON user.person REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLAREBEGIN --新增 IF INSERTING THEN INSERT INTO personbak VALUES ...); END IF; IF UPDATING THEN update personbak ....;
AFTER DELETE OR INSERT OR UPDATE
ON user.person
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLAREBEGIN
--新增
IF INSERTING
THEN
INSERT INTO personbak
VALUES ...);
END IF; IF UPDATING
THEN
update personbak ....;
END IF;
END;