表t1有个插入触发器往t2插入数据
create trigger tg1 after insert on t1
begin
replace into t2(f1) values(new.f1);
end;
,可以成功触发并插入,
表t2有个更新触发器,将更新前的字段值插入t3表中
create trigger tg2 before update of f10 on t2
begin
insert into t3(f1) values(old.f1);
end;
可t2这个触发器不能被触发,这是为什么,replace不能触发更新吗?
------解决方案--------------------------------------------------------
create trigger tg2 before insert of f10 on t2
begin
insert into t3(f1) values(old.f1);
end;