MySQL with 2 stored procedures with return value and no return value

Procedure 1: With return value:

1 Drop procedure if existsProc_addnum;2 Create procedureProc_addnum (inchXint,inchYint, outsum int)3 BEGIN4 SET sum=X+y;5 End

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

1 Call Proc_addnum (2,3,@sum); 2 Select @sum;

Procedure 2: No return value:

1 Drop procedure if existsProc_addnum;2 Create procedureProc_addnum (inchXint,inchYint)3 BEGIN4 DECLARE sum int;5 SET sum=X+y;6 SELECT sum;7 End

Execution process:

1 Call Proc_addnum (2,3);

MySQL with 2 stored procedures with return value and no return value