Mysql Stored Procedure

Mysql Stored Procedure

Process 1: With return values:

Drop procedure if exists proc_addNum; create procedure proc_addNum (in x int, in y int, out sum int) begin set sum = x + y; end

Then, in the execution process, the out output return value:

Call proc_addNum (2, 3, @ sum); select @ sum;

Process 2: without the return value:

Drop procedure if exists proc_addNum; create procedure proc_addNum (in x int, in y int) begin declare sum int; SET sum = x + y; SELECT sum; end

Execution Process:

Call proc_addNum (2, 3 );

Summary

The above is a small series of two Stored Procedure writing methods for Mysql with and without return values. I hope this will be helpful to you. If you have any questions, please leave a message, the editor will reply to you in time!