MySQL存储过程、游标的使用

DELIMITER $$
USE chufaqi$$
DROP PROCEDURE IF EXISTS `up_test1`$$
CREATE PROCEDURE up_test1()
BEGIN
    DECLARE i_id INT;
    DECLARE i_name VARCHAR(20);
    DECLARE cur_test CURSOR FOR SELECT id,NAME FROM test1;
    DECLARE EXIT HANDLER FOR NOT FOUND CLOSE cur_test;

    OPEN cur_test;
    WHILE 1=1 DO
    FETCH cur_test INTO i_id,i_name;

    IF i_id <100 THEN
    UPDATE test1 SET NAME=CONCAT(i_id,i_name) WHERE id=i_id;
    ELSE
    UPDATE test1 SET NAME=CONCAT(1,i_name) WHERE id=i_id;
    END IF;

    END WHILE;
CLOSE cur_test;
END$$
DELIMITER ;