存储过程1:
delimiter ,,
create procedure in_param(in p_in int )
begin
select p_in;
set p_in=2;
select p_in;
end;;
delimiter ,
存储过程2:
delimiter ,,
create procedure in_param(in p_in int )
begin
select p_in;
set p_in=(select warn_entity_num from waimai_statistics_warn where id='118518');
if (p_in = 2408)
THEN
select 'ok';
else
select 'wrong';
END if;
END;;
delimiter ,
参数赋值:
set @p_in=(select warn_entity_num from waimai_statistics_warn where id='118518')
存储过程调用:
call in_param(@p_in) 或者 call in_param(234)
https://www.cnblogs.com/chaoa/articles/3894311.html ----- 存储过程一些基本语法