db2使用触发器更新数据修改时间字段

----创建测试库表
create table test_triger (
  id varchar(5),
  test_name varchar(100),
  create_time timestamp default current_timestamp,
  update_time timestamp default current_timestamp
);
----创建触发器
CREATE OR REPLACE  TRIGGER tri_update_test

  AFTER UPDATE OF test_name ON test_triger

  REFERENCING OLD AS OLD NEW AS NEW --old,new新旧数据别名

  FOR EACH ROW MODE DB2SQL--行级触发

BEGIN ATOMIC

update test_triger set update_time = current_timestamp where id = OLD.id;

END
----------------添加测试数据
insert into test_triger(id,test_name) VALUES ('11111','张三');
insert into test_triger(id,test_name) VALUES ('22222','李四');
commit;
----------------
update test_triger set test_name = '李四' where id = '55555';
commit;
----------------
delete from test_triger;
commit;
----------------
select * from test_triger;
----------------
drop table test_triger;
----------------
drop trigger tri_update_test;