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; //設(shè)置全局變量
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);
到此這篇關(guān)于MySQL存儲過程in、out和inout參數(shù)示例和總結(jié)的文章就介紹到這了,更多相關(guān)MySQL存儲過程in、out和inout參數(shù)內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!