mysql多层循环语句,MySQL高级三——循环语句

1、where循环create procedure p_addnum()

begin

declare i int default 1;

declare addresult int default 0;

while i <= 100 do

set addresult = addresult + i;

set i = i + 1;

end while;

select addresult;

end;

$$;

2、repeat循环create procedure p_updatenum()

begin

declare imin int default 1;

declare value int default 1;

declare imax int default 100;

repeat

select value;

set value = value + 1;

set imin = imin + 1;

until imin > imax

end repeat;

end;

$$;

3、loop循环create procedure p_updateloop()

begin

declare imin int default 1;

declare value int default 1;

declare imax int default 100;

myloop:loop

select value;

set value = value + 1;

set imin = imin + 1;

if imin > imax then

leave myloop;

end if;

end loop;

end;

$$;

以上就是MySQL高级三——循环语句的内容，更多相关内容请关注PHP中文网(www.gxlcms.com)！

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网