On Wed, 25 Oct 2006, Paul DuBois wrote:

At 17:33 -0400 10/25/06, Waldemar Jankowski wrote:
Hello everyone,
I'm wondering if there is a way to exit out of a REAPEAT/WHILE loop iteration in a stored procedure. I think LEAVE will get you out of the loop completely, but I looking for something like "next" record.

Perhaps you want ITERATE:

http://dev.mysql.com/doc/refman/5.0/en/iterate-statement.html

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Perfect. Thank you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to