repeat结构
-- 计算从1加到n的值 -------> repeat
create procedure pro_test9(n int)
begin
declare total int default 0;
repeat
set total=total+n;
set n=n-1;
until n=0
end repeat;
select total;
end$
-- 计算从1加到n的值 -------> repeat
create procedure pro_test9(n int)
begin
declare total int default 0;
repeat
set total=total+n;
set n=n-1;
until n=0
end repeat;
select total;
end$