Skip navigation links
12.7.7 RETURN Syntax »
Section Navigation      [Toggle]

12.7.6.7. WHILE Statement

[begin_label:] WHILE search_condition DO
    statement_list
END WHILE [end_label]

The statement list within a WHILE statement is repeated as long as the search_condition is true. statement_list consists of one or more statements.

A WHILE statement can be labeled. See Section 12.7.1, “BEGIN ... END Compound Statement Syntax” for the rules regarding label use.

Example: 

CREATE PROCEDURE dowhile()
BEGIN
  DECLARE v1 INT DEFAULT 5;

  WHILE v1 > 0 DO
    ...
    SET v1 = v1 - 1;
  END WHILE;
END

User Comments

Posted by Neil Davis on January 16 2008 4:04am[Delete] [Edit]

If the above example doesn't work for you,
wrap the statements within the while loop with BEGIN/END.
WHILE [condition] DO
BEGIN
..code...
END;
END WHILE;

Had to do this on windows to get mysql to add function. Still testing...

-neil

Add your own comment.