分类：mysql存储过程写法和调用

2021
01-08

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

存储过程1.创建存储过程并查看全局变量mysql>createdatabaseyy;QueryOK,1rowaffected(0.00sec)mysql>useyy;Databasechangedmysql>set@num1=10,@num2=20,@num3=30;//设置全局变量mysql>delimiter$$mysql>createprocedurep(innum1int,outnum2int,inoutnum3int)->begin->selectnum1,num2,num3;->setnum1=100,num2=200,num3=300;->selectnum1,num2,num3;->end$$QueryOK,0rowsaffected(0.... 继续阅读 >