- Documentation Library
- Table of Contents
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Manual de Referência do MySQL 4.1 :: 11 Stored Procedures e Funções :: 11.1 Sintaxe de Stored Procedure :: 11.1.9 Flow Control Constructs :: 11.1.9.5 ITERATE Statement
Section Navigation [Toggle]
ITERATE label
ITERATE can only appear within
LOOP, REPEAT, and
WHILE statements.
ITERATE means ``do the loop iteration
again.''
For example:
CREATE PROCEDURE doiterate(p1 INT)
BEGIN
label1: LOOP
SET p1 = p1 + 1;
IF p1 < 10 THEN ITERATE label1; END IF;
LEAVE label1;
END LOOP label1;
SET @x = p1;
END
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
