MySQL cheatsheet: flow control

flowcontrol.sql

-- if-else
IF boolean_condition THEN
    -- ... instructions ...
[ELSEIF boolean_condition THEN] 
    -- ... instructions ...
ELSE
    -- ... instructions ...
END IF

-- normal loop
LOOP
    -- ... instructions ...
    LEAVE; -- it's really important to leave the loop, if not, it'll run forever
END LOOP;

-- while loop
WHILE boolean_condition DO
    -- ... instructions ...
END WHILE;

-- do-while loop
REPEAT
    -- ... instructions ...
UNTIL boolean_condition;
END REPEAT;