db2 触发器

create trigger tri_new_userafter insert on tb_userfor each rowupdate tb_company_stats set user_count = user_count + 1;

create table tb_company_stats(user_count int default 0)

insert into tb_company_stats values (0)

db2 => create trigger tri_new_userdb2 (cont.) => after insert on tb_userdb2 (cont.) => for each rowdb2 (cont.) => update tb_company_stats set user_count = user_count + 1   db2 (cont.) => @DB20000I  The SQL command completed successfully.

create trigger tri_delete_userafter delete on tb_userfor each rowupdate tb_company_stats set user_count = user_count - 1

db2 => create trigger tri_delete_userdb2 (cont.) => after delete on tb_userdb2 (cont.) => for each rowdb2 (cont.) => update tb_company_stats set user_count = user_count - 1db2 (cont.) => @DB20000I  The SQL command completed successfully.