mysql最简单的存储过程

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();

 

 

 

drop procedure if exists pro2;
create procedure pro2()
begin
DECLARE param int;
SET param = HOUR ( date_add(NOW(), interval 8 hour) );

if param=20 then
select param;
elseif param=20 then
select param;
else
select param;
end if;
end;

 

CALL pro2();