Two ways to write stored procedures in Mysql with and without return values

Process 1: with return value:

 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, execute the process and output the return value:

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

Procedure 2: Without 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);

Summarize

The above is the two ways of writing MySQL stored procedures with and without return values ​​that I introduced to you. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time!