navicat中增加触发器,定义如下:
begin
if (operation.Implant='strauman') then
insert into operation(Implant_id) SELECT Strauman_id from strauman;
ELSE IF (operation.Implant='nobel') then
insert into operation(Implant_id) SELECT nobel_id from nobel;
end if;
End
保存时出现end附近语法错误。请高手帮助