Mysql存储过程怎么跳出死循环While语句的方法。

[莳杉捻荮]

DROP PROCEDURE IF EXISTS `Sum_wage`;

CREATE DEFINER = `root`@`localhost` PROCEDURE `Sum_wage`(pwage int,awage int)
BEGIN
WHILE 1=1 DO
if (select count(*) from ProWage)>2*(select count(*) from ProWage where Wage>=@PWage) 
then update ProWage set Wage=Wage+AWage;
ELSE
goto label_name;
end if;
END WHILE;
LABEL label_name;
END;

其中goto label_name; LABEL label_name;报错。请问Mysql存储过程中不支持GOTO，LABEL吗？
另外在else中想跳出循环，怎么做？

[rucypli]

直接 WHILE (select count(*) from ProWage)>2*(select count(*) from ProWage where Wage>=@PWage) do update end while

[wwwwb]

ELIMITER $$ DROP PROCEDURE IF EXISTS `Sum_wage`$$ CREATE DEFINER = `root`@`localhost` PROCEDURE `Sum_wage`(pwage INT,awage INT) BEGIN tt:WHILE 1=1 DO IF (SELECT COUNT(*) FROM ProWage)>2*(SELECT COUNT(*) FROM ProWage WHERE Wage>=@PWage) THEN UPDATE ProWage SET Wage=Wage+AWage; ELSE LEAVE tt; END IF; END WHILE; END$$ DELIMITER ;

[莳杉捻荮]

嗯。两个都可以。谢谢哈！还有个问题就是Mysql存储过程中不支持GOTO，LABEL吗？