Re: equivalent of for <record> in <cursor> loop....end loop;

[Andrew Gilfrin]

There isn't an equivalent to Oracles cursor for loop.

The if not done statment can be a little tricky to work out. What is acyually happening is that when the cursor can no longer return rows it raises the exception 02000 (ER_SP_FETCH_NO_DATA) which is caught by an exception handler (which you need to specify). In the example you give it must be setting a vaiable called done to 1 so that the IF statement fails.

Take the following as an alternative which may halp to make sense of what I'm saying.

http://mysql.gilfster.com/source/cursorproc2.myp

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information



Edited 1 time(s). Last edit at 03/14/2006 08:29AM by Andrew Gilfrin.