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