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;