要求;
create procedure xingqi1()
begin
declare shu int;
declare xq varchar(20);
set shu=2;
case shu
when 1 then
set xq='星期一';
when 2 then
set xq='星期二';
when 3 then
set xq='星期三';
when 4 then
set xq='星期四';
when 5 then
set xq='星期五';
when 6 then
set xq='星期六';
when 7 then
set xq='星期日';
end case;
select xq;
end;
call xingqi1();