Loop operations in MySQL stored procedures

Execute loop operations with the cursor Drop   Procedure   If   Exists Sp_opr;
Create   Procedure Sp_opr ()
Begin

/**/ /*Define variable 1*/
Declare _ Err_code Char ( 8 ) Default   '' ;
/**/ /*Define variable 2*/
Declare _ CNT Int   Default   0 ;

/**/ /*Cursor*/
Declare _ Done Int   Default   0 ;
Declare _ Cur_error Cursor   For
Select Col1, col2 From   Table   Where Rec_dd = Adddate (curdate (), - 1 );
Declare   Continue Handler For Sqlstate ' 02000 '   Set _ Done =   1 ;

/**/ /*Open cursor*/
Open _ Cur_error;
/**/ /*Loop execution*/
Repeat
Fetch _ Cur_error Into _ Err_code, _ CNT; -- Read the next row

If   Not _ Done Then
-- The code here is executed cyclically (the value read above can be used here)
End   If ;

Until _ done End Repeat; -- When _ DONE = 1, the system exits

/**/ /*Close the cursor*/
Close _ Cur_error;

End ;