MYSQL存储过程内循环

DELIMITER $$
CREATEPROCEDURE `data_name`.`test`(i INT(2))BEGIN
WHILE i > 0 DO 
/*这里写sql*/
UPDATE `doctor_info` SET  doctor_name=CONCAT(doctor_name,i);SET i=i-1;
END WHILE;END$$
DELIMITER ;