SQL创建触发器

CREATE TABLE TEST2(\"TIME\" DATETIME\"USER\" VARCHARID1 INTOLDID2 VARCHARNEWID2 VARCHAR); CREATE TABLE TEST1(ID1 INTID2 VARCHAR); INSERT INTO TEST1 VALUES(11'A'); INSERT INTO TEST1 VALUES(12'B'); INSERT INTO TEST1 VALUES(13'C'); INSERT INTO TEST1 VALUES(14'D'); INSERT INTO TEST1 VALUES(15'E'); INSERT INTO TEST1 VALUES(16'F'); INSERT INTO TEST1 VALUES(17'G'); INSERT INTO TEST1 VALUES(18'H'); INSERT INTO TEST1 VALUES(19'I');

--创建触发器

CREATE TRIGGER CFQ--新建触发器名称

BEFORE UPDATE OF ID2 ON TEST1--在更改TEST1表的ID2列之前 FOR EACH ROW--或者FOR EACH STATEMENT BEGIN

INSERT INTO TEST2 (\"TIME\"\"USER\"ID1OLDID2NEWID2) VALUES (SYSDATE()USER:OLD.ID1:OLD.ID2:NEW.ID2);--获取当前用户，时间，更改前的值，更改后的值，记录到TEST1表 END;

--更改ID2的值为ZZ

UPDATE TEST1 SET ID2='ZZ' WHERE ID1=11; SELECT * FROM TEST2;--查看TEST2