create PROCEDURE getGrade(in flag int)
BEGIN
DECLARE str VARCHAR(2);
if flag =1 THEN
set str= '优';
elseif flag=1 then
set str= '良';
else
set str= '差';
end if;
select str;
end
create PROCEDURE getGrade(in flag int)
BEGIN
DECLARE str VARCHAR(2);
if flag =1 THEN
set str= '优';
elseif flag=1 then
set str= '良';
else
set str= '差';
end if;
select str;
end