总结MySQL存储过程in、out、inout参数示例

mysql> create database yy;Query OK, 1 row affected (0.00 sec)mysql> use yy;Database changed

mysql> set @num1=10,@num2=20,@num3=30;   //设置全局变量mysql> delimiter $$

mysql> create procedure p(in num1 int,out num2 int,inout num3 int)

    -> begin    -> select num1,num2,num3;

    -> set num1=100,num2=200,num3=300;

    -> select num1,num2,num3;

    -> end $$

Query OK, 0 rows affected (0.00 sec)mysql> delimiter ;mysql> call p(@num1,@num2,@num3);