mysql 存储过程

create procedure proc6()
begin
declare i int;
declare j int;
declare k int;


set i=20000001;
set j=40000001;
set k=60000001;


LOOP_LABLE:loop  
  xxxx
xxxx set i=i+1; set j=j+1; set k=k+1; if i >20000002 then leave LOOP_LABLE; end if; end loop; end



posted on 2013-09-25 08:47  babyblue  阅读(113)  评论(0)    收藏  举报