MySQL 5.0 Reference Manual :: 17 Stored Procedures and Functions :: 17.2 Stored Routine Syntax :: 17.2.10 Flow Control Constructs
Section Navigation [Toggle]
- 17.2 Stored Routine Syntax
- 17.2.1 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 17.2.2 ALTER PROCEDURE and ALTER FUNCTION Syntax
- 17.2.3 DROP PROCEDURE and DROP FUNCTION Syntax
- 17.2.4 CALL Statement Syntax
- 17.2.5 BEGIN ... END Compound Statement Syntax
- 17.2.6 DECLARE Statement Syntax
- 17.2.7 Variables in Stored Routines
- 17.2.8 Conditions and Handlers
- 17.2.9 Cursors
- 17.2.10 Flow Control Constructs
The IF, CASE,
LOOP, WHILE,
REPLACE ITERATE, and
LEAVE constructs are fully implemented.
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 currently supported.
User Comments
Add your own comment.