存储过程定义:
delimiter$$
drop procedure if exists p_numbertest$$
create procedure p_numbertest(input_number int,out out_type varchar(2))
begin
if(input_number=0) then
set out_type = ‘0’;
elseif((input_number%2)=0) then
set out_type = ‘偶’;
else
set out_type =‘奇’;
end if;
end$$
delimiter;
调用:
mysql> call p_numbertest(60,@result);
报错:Unknown column '‘偶’' in 'field list'