drop procedure if exists pro2;
create procedure pro2()
begin
DECLARE param VARCHAR(100);
set param='你好';
if param='你好' then
select NOW();
elseif param='我好' then
select NOW();
else
select NOW();
end if;
end;

--调用

CALL pro2();