#创建存储过程实现传入两女神生日返回大小
CREATE PROCEDURE f2(in bir date,in bir2 date,OUT result VARCHAR)
BEGIN
IF to_days(bir)>to_days(bir2) THEN result='大';
ELSEIF to_days(bir)<to_days(bir2) THEN result='小';
end IF;
END;
CREATE PROCEDURE f2(in bir date,in bir2 date,OUT result VARCHAR(20))
BEGIN
CASE
WHEN to_days(bir)>to_days(bir2) THEN result=a
;
ELSE result=b
;
END CASE;
END;