MySQL 存储过程之游标

BEGIN
     DECLARE Done INT DEFAULT 0;
     DECLARE id_ INT;
     DECLARE name_ VARCHAR(30);
     /* 声明游标 */
     DECLARE v_cur CURSOR FOR SELECT id_,name_ FROM t;
     /* 异常处理 */
     DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET Done = 1;
    
     /* 打开游标 */
     OPEN v_cur;  
    
     /* 逐个取出当前记录LingQi字段的值，需要进行最大值的判断 */
     FETCH NEXT FROM v_cur INTO id_, name_;     
     /* 遍历数据表 */
     REPEAT
           IF NOT Done THEN
              ........
           END IF;
     FETCH NEXT FROM v_cur INTO id_, name_;

     UNTIL Done END REPEAT;
    
     /* 关闭游标 */
     CLOSE v_cur;
END