delimiter $$
create procedure p(in salary int, out result varchar(10))
begin
if salary >= 30000 then
set result := '管理层';
elseif salary >= 12000 then
set result := '优秀员工';
elseif salary >= 8000 then
set result := '正式员工';
elseif salary >= 4000 then
set result := '普通员工';
else
set result := '实习生';
end if;
end;
$$
delimiter ;
call p(3000,@result);
select @result;
效果图: