MySQL学习笔记：repeat、loop循环

# ---- repeat ----
DELIMITER $$
CREATE PROCEDURE test_repeat()
BEGIN
    DECLARE a INT DEFAULT 10;
    REPEAT
        SET a = a - 1;
        UNTIL a < 5
    END REPEAT;
    
    SELECT a;
END $$
DELIMITER ;

# 调用
CALL test_repeat();

# 删除
DROP PROCEDURE test_repeat;

# ---- loop ----
DELIMITER $$
CREATE PROCEDURE test_loop()
BEGIN
    DECLARE t INT DEFAULT 0;
    label:LOOP
        SET t = t + 1;
        IF t > 10 THEN LEAVE label;
        END IF;
    END LOOP label;
    
    SELECT t;
END $$
DELIMITER ;

# 调用
CALL test_loop();

# 删除
DROP PROCEDURE test_loop;