MYSQL游标的使用

有问题，要检查一下：

DELIMITER |

CREATE PROCEDURE sortTable()
BEGIN
DECLARE val INT;
SET val = 1;
DECLARE curTable CURSOR FOR SELECT * FROM t_ruanko_ke_answer ORDER BY qid ASC;
/*游标 异常后 捕捉 并设置 循环使用 变量 tmpname 为 null 跳出循环。*/
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET tmpname = NULL;
/*开游标*/ 
OPEN curTable;
/*游标向下走一步*/ 
        FETCH curTable INTO tmpName;
        WHILE( tmpname IS NOT NULL ) DO
UPDATE t_ruanko_ke_answer SET id = val;
SET val = val+1;
FETCH curTable INTO tmpName;
END WHILE;
CLOSE curTable;
END|