Re: How do you exit a procedure

[Peter Brawley]

You can use IF ... ENDIF, REPEAT ... UNTIL, and/or WHILE, eg...

DELIMITER |
CREATE PROCEDURE whileproc()
BEGIN
DECLARE condition INT DEFAULT 1;
WHILE condition DO BEGIN
... code which may set the value of condition ...
END WHILE;
END;
|
DELIMITER ;