Skip navigation links
12.7.6.1 IF Statement »
Section Navigation      [Toggle]

12.7.6. Flow Control Constructs

[+/-]

12.7.6.1. IF Statement
12.7.6.2. CASE Statement
12.7.6.3. LOOP Statement
12.7.6.4. LEAVE Statement
12.7.6.5. ITERATE Statement
12.7.6.6. REPEAT Statement
12.7.6.7. WHILE Statement

MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs.

Many of these constructs contain other statements, as indicated by the grammar specifications in the following sections. Such constructs may be nested. For example, an IF statement might contain a WHILE loop, which itself contains a CASE statement.

FOR loops are not supported.