MySQL LOOP Syntax

In MySQL, a LOOP statement can be used to repeatedly execute a block of code. The correct syntax for a MySQL LOOP is as follows:

LOOP
    -- Code to be executed
END LOOP

To exit the loop early, you can use the LEAVE statement. The LEAVE statement takes a label as an argument. When the LEAVE statement is executed, the loop with the matching label will be exited.

LOOP label1
    -- Code to be executed
    LEAVE label1
END LOOP label1

Example

The following example demonstrates how to use a LOOP statement to iterate through a range of values:

DECLARE i INT DEFAULT 1;
DECLARE max_value INT DEFAULT 10;

LOOP
    SELECT i FROM DUAL;
    SET i = i   1;
    IF i > max_value THEN
        LEAVE;
    END IF;
END LOOP;