要求;
create procedure xingqi( inout i int)
begin
declare n int;
declare result varchar(10);
set n=i;
case n
when 0 then
set result='星期日';
when 1 then
set result='星期一';
when 2 then
set result='星期二';
when 3 then
set result='星期三';
when 4 then
set result='星期四';
when 5 then
set result='星期五';
else
set result='星期六';
end case;
select n,result ;
end;
set @x=4;
call xingqi(@x);
select @x;