带参触发器简单例子测试
发布时间:2020-12-12 15:31:42 所属栏目:百科 来源:网络整理
导读:create table Test ( iKey int, iValue int, primary key(iKey) ); create table Test_Log ( iKey int, iClass varchar(4) ); create trigger Test_Tri after insert on Test for each row begin if :new.iValue90 then insert into Test_log values(:new.iKe
create table Test
( iKey int, iValue int, primary key(iKey) ); create table Test_Log ( iKey int, iClass varchar(4) ); create trigger Test_Tri after insert on Test for each row begin if :new.iValue>90 then insert into Test_log values(:new.iKey,1); end if; end; insert into Test values(12,120); insert into Test values(18,60); insert into Test values(10,90); insert into Test values(20,91); insert into Test values(21,92);
http://blog.csdn.net/i792439187/article/details/8826751 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |