游标使用例子

CREATE DEFINER=`root`@`%` PROCEDURE `P_Zghpjz`()
BEGIN
#Routine body goes here...
 
  
  DECLARE tmpName VARCHAR(20) DEFAULT '';  /*游标 判断变量 */
   /*创建游标*/
   declare curl CURSOR FOR Select ywdm,jgdm,rwh  From si_zkb_io  Where rwzt='2' AND fx ='1' AND flag = '0';
   declare CONTINUE HANDLER FOR SQLSTATE '02000' SET tmpName = null; #设定游标结束状态
   
/*打开游标*/
     OPEN curl;
     FETCH curl INTO s_ywdm,s_jgdm,s_rwh;
/****循环体***/
     WHILE ( tmpName is not null) DO


 FETCH curl INTO s_ywdm,s_jgdm,s_rwh;#循环游标
END WHILE;
  
      CLOSE curl;#关闭游标






END