delimiter !
create trigger bmoney after insert on c
for each row
begin
update b set bmoney = bmoney + new.cmoney where bid = new.bid;
end;
! 报错:
ERROR 1314 (0A000): Statements like SELECT, INSERT, UPDATE (and others) are not
allowed in a FUNCTION请各位大哥解释下
create trigger bmoney after insert on c
for each row
begin
update b set bmoney = bmoney + new.cmoney where bid = new.bid;
end;
! 报错:
ERROR 1314 (0A000): Statements like SELECT, INSERT, UPDATE (and others) are not
allowed in a FUNCTION请各位大哥解释下
!
改为
end!