[MySQL光速入门]019 分别使用loop, while, repeat 来计算从0加到100 答案

猫哥的技术博客

2019-04-10 904 阅读1分钟

`while`

drop procedure if exists make_sum;
create procedure make_sum() begin 
    declare num int default 0;
    declare res int default 0;
    while num<=100 do 
        set res = res + num;
        set num = num + 1;
    end while;
    select res;
end;
call make_sum();

loop

drop procedure if exists make_sum;
create procedure make_sum() begin 
    declare num int default 0;
    declare res int default 0;
    myloop:loop 
        set res = res + num;
        set num = num + 1;
        if num > 100 then leave myloop;
        end if;
    end loop;
    select res;
end;
call make_sum();

repeat

drop procedure if exists make_sum;
create procedure make_sum() begin 
    declare num int default 0;
    declare res int default 0;
    repeat 
        set res = res + num;
        set num = num + 1;
    until 
        num > 100
    end repeat;
    select res;
end;
call make_sum();

快速跳转