请教Mysql存储过程退出循环的问题

2025-03-18 20:05:41
推荐回答(1个)
回答1:

ELIMITER $$DROP PROCEDURE IF EXISTS `Sum_wage`$$ CREATE DEFINER = `root`@`localhost` PROCEDURE `Sum_wage`(pwage INT,awage INT)BEGINtt:WHILE 1=1 DOIF (SELECT COUNT(*) FROM ProWage)>2*(SELECT COUNT(*) FROM ProWage WHERE Wage>=@PW...