--建一个Insert,一个update触发器就可以了.create trigger tri_up_sh
after update on a for each row
begin
if new.sh=2 then
insert into b select new.id;
end if;
end;create trigger tri_ins_sh
after insert on a for each row
begin
if new.sh=2 then
insert into b select new.id;
end if;
end;
after update on a for each row
begin
if new.sh=2 then
insert into b select new.id;
end if;
end;create trigger tri_ins_sh
after insert on a for each row
begin
if new.sh=2 then
insert into b select new.id;
end if;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货