MySQL创建存储过程输入参数是员工姓名根据该员工的奖金comm来判定员工的等级。-- comm=5000 等级为 A-- 4000=comm5000 等级为 B-- 3000=comm4000 等级为 C-- comm3000 等级为D-- 无奖金 等级为E

DELIMITER //

CREATE PROCEDURE get_employee_level(IN employee_name VARCHAR(50)) BEGIN DECLARE employee_comm INT; DECLARE employee_level CHAR(1);

SELECT `comm` INTO `employee_comm` FROM `employees` WHERE `first_name` = `employee_name`;

IF (`employee_comm` >= 5000) THEN
    SET `employee_level` = 'A';
ELSEIF (`employee_comm` >= 4000 AND `employee_comm` < 5000) THEN
    SET `employee_level` = 'B';
ELSEIF (`employee_comm` >= 3000 AND `employee_comm` < 4000) THEN
    SET `employee_level` = 'C';
ELSEIF (`employee_comm` < 3000 AND `employee_comm` IS NOT NULL) THEN
    SET `employee_level` = 'D';
ELSE
    SET `employee_level` = 'E';
END IF;

SELECT `employee_name`, `employee_level`;

END//

DELIMITER