第1个回答 2013-05-23
给你个例子:
for loop是这样的:
createprocedure pro
begin
declare aintdefault1;
label1: loop
if a<6then
selecta;
seta=a+1;
iterate label1;
endif;
leave label1; 跳出循环
endloop label1;
end
while是这样的:
createprocedure pro
begin
declare aintdefault4;
while a<10 do
selecta;
seta=a+1;
endwhile;
end