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中文网