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

[corne lombard]

In Oracle, we can do

for <record> in <cursor> (parameter1, parameter 2)
loop


end loop;

Is this the best solution for mysql 5.0 ?

open <cursor> (parameters allowed here ????);
repeat
fetch <cursor> into <variable1, variable2>;
If not done then

end if;
until done end repeat;
close <cursor>


Corne
OCP

The line ' If not done then ', does this check equates to check for more records in cursor ?

Thanks



Edited 1 time(s). Last edit at 03/14/2006 06:19AM by corne lombard.