DELIMITER $$
CREATE
PROCEDURE `test`.`pro_update`()
BEGIN
DECLARE currentId INT (11);
DECLARE Done INT DEFAULT 0;
DECLARE cu CURSOR FOR SELECT id FROM tba;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET Done = 1;
OPEN cu;
REPEAT
FETCH cu INTO currentId;
IF Done=0 THEN
UPDATE tba SET NAME=CONCAT(`name`,`id`) WHERE id=currentId;
END IF;
FETCH cu INTO currentId;
UNTIL Done=1 END REPEAT;
CLOSE cu;
END$$
DELIMITER ;