[MySQL光速入門]019 分別使用loop, while, repeat 來計算 從0加到100 答案

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();
複製程式碼

快速跳轉

• [MySQL光速入門]018 流程控制
• [MySQL光速入門]020 事務