mysql 终止循环

DELIMITER //

CREATE PROCEDURE example_procedure()
BEGIN
    DECLARE counter INT DEFAULT 0;

    loop_label: LOOP
        SET counter = counter + 1;

        IF counter > 10 THEN
            LEAVE loop_label; -- 终止循环
        END IF;

        -- 循环体逻辑
    END LOOP loop_label;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE example_procedure()
BEGIN
    DECLARE counter INT DEFAULT 0;
    DECLARE max_iterations INT DEFAULT 10;

    WHILE counter <= max_iterations DO
        SET counter = counter + 1;

        -- 循环体逻辑

        IF counter > max_iterations THEN
            LEAVE example_procedure; -- 终止存储过程
        END IF;
    END WHILE;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE example_procedure()
BEGIN
    DECLARE counter INT DEFAULT 0;
    DECLARE should_exit BOOLEAN DEFAULT FALSE;

    loop_label: LOOP
        SET counter = counter + 1;

        -- 检查某个条件，如果满足则终止循环
        IF should_exit THEN
            LEAVE loop_label;
        END IF;

        -- 循环体逻辑
    END LOOP loop_label;
END //

DELIMITER ;