procedure in out的使用

drop procedure if exists pro_user_return_test;
create procedure pro_user_return_test
(
in param_id int,
in param_name varchar(10),-- in 类型的 MySQL 存储过程参数
out param_count int
)
begin
case when  (param_id!=0 and param_name is not null) then
 insert into user(id,name) values(param_id,param_name);
set param_count=1;
else
 set param_count=0;
end case;
end;


call pro_user_return_test(2,'李四',@param_count);
select @param_count