MySQL-Cursor-Nutzungsvorlage

BEGIN 
   /**  
     *   
     * 游标模版  
     * @author xuyw  
     * @email xyw10000@163.com  
     * @date 2014-05-19  
     */  
     /*游标数据变量 uid*/  
    DECLARE uid VARCHAR(128);  
    DECLARE done INT DEFAULT 0;  
       
    /*查询所有用户*/  
    DECLARE cur CURSOR FOR SELECT xxx FROM xx;  
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;  
  OPEN cur;  
    /* 开始循环*/  
    REPEAT  
    /* 提取游标里的数据*/  
    FETCH cur INTO uid;  
    IF done =0 THEN  
    执行你的业务  
   END IF;  
  UNTIL done=1  
  END REPEAT;  
  /*关闭游标*/  
  CLOSE cur;  
END;