Bug #68758 Procedures: Simpler iteration through result of SELECT
Submitted: 24 Mar 2013 9:09
Reporter: Ondrej Zizka Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any

[24 Mar 2013 9:09] Ondrej Zizka 
Description:
Currently, to go through a result, one has to use quite complex syntax.
http://dev.mysql.com/doc/refman/5.0/en/cursors.html

It would be nice if one could iterate like this:

FOR (id, data) AS SELECT id, data FROM test.t1 BEGIN
   ## ... do something...
   IF ...
      CONTINUE;
   ...
END

Thanks for considering.

How to repeat:
.

Suggested fix:
.