SQL 存储过程：循环降薪至平均薪资 5000

CREATE PROCEDURE updata_salary_while(OUT num INT) BEGIN DECLARE avg_salary FLOAT; DECLARE cnt INT DEFAULT 0; SELECT AVG(salary) INTO avg_salary FROM employee; WHILE avg_salary > 5000 DO UPDATE employee SET salary = salary * 0.9; SELECT AVG(salary) INTO avg_salary FROM employee; SET cnt = cnt + 1; END WHILE; SET num = cnt; END;