MYSQL中新建函数push_money如下,在mysql中新建成功,但是调用不出来结果,output处显示ok,还请各位大神帮忙查看下原因,谢谢!
delimiter //
create function push_money(saler char(5))
returns decimal(6,2)
begin
declare grade int;
declare amount int;
select performance into amount from sale where sale=saler;
if amount>100 then
set grade = 0.1;
elseif amount>70 then
set grade = 0.05;
elseif amount>40 then
set grade = 0.02;
else
set grade = 0;
end if;
return grade;
end //
delimiter ;
#function 新建成功
select sale,performance,push_money(sale) from performance;
调用function没有结果出来
直接调用函数试下
select push_money('名称') #将名称替换成表中存在的值