MySQL 存储过程参数的类型与特点

存储过程参复制begin if (id is not null) then set idid = id + 1; end if; select id as id_inner;end; set @id = 10;call pr_param_in(@id);select @id as id_out; mysql> call pr_param_in(@id); +----------+| id_inner |+----------+| 11 |+---------+mysql> select @id as id_out; +--------+| id_out |+--------+| 10 |+--------+ 1.2.3.4.5.6.