为什么调用这个存储过程会死循环?
delimiter $$CREATE procedure sett93c(in apid int,in adesignation varchar(30),in areference varchar(30),in apic varchar(30),in amnote varchar(850),in amark varchar(20))beginloop_label: loopIf apid<0 then leave loop_label;elseinsert into t93c(pid,name,reference,pic,mnote,mark) values(apid,adesignation,areference,apic,amnote,amark); leave loop_label;end if;end loop;end$$ 没人知道吗?
页:
[1]