How to use MySQL Cursors

BEGIN/*Calculate User Commission total amount*/DeclareAmountprice,pays,rates,goodsprice DECIMAL (10,2)DEFAULT0;DECLAREFlag int,getUserId;#if (userlevel=1) ThenSELECT member_id to getUserId from 33hao_member where OpenID=open_idDeclareCUR cursor forSelect Commission1_rate Rates,commission1_pay pays,goods_price from 33hao_goods_common;DECLARE CONTINUEHANDLER forNot FOUND SET flag=1; SET Flag=0; OPEN cur; Repeatfetch cur into rates, Pays,Goodsprice;if(rates=NULL) Then set Amountprice=amountprice+pays;ELSESet Amountprice=amountprice+goodsprice*rates;End if; UNTIL FlagEndREPEAT; CLOSE cur;RETURNAmountprice;End

How to use MySQL Cursors