MySQL Create a detailed example tutorial for stored procedures (1/9)

MySQL tutorial Creating stored Procedures
"Pr_add" is a simple MySQL stored procedure that has two input parameters of type int, "A", "B", and returns the and of the two parameters.

drop procedure if exists pr_add;

--Calculate the sum of two numbers

CREATE PROCEDURE Pr_add
(
a int,
b int
)
Begin
declare c int;

If A is null then
Set a = 0;
End If;

If B is null then
Set B = 0;
End If;

Set C = a B;

Select C as Sum;

/*
return C; --cannot be used in a MySQL stored procedure. Return can only appear in the function.
*/
End
Second, call the MySQL stored procedure
Call Pr_add (10, 20);
Execute the MySQL stored procedure, the stored procedure parameter is the MySQL user variable.

Set @a = 10;
Set @b = 20;

Home 1 2 3 4 5 6 7 8 9 last