MySQL Stored Procedure

1. Create the Stored Procedure drop procedure if exists sp_test;
Create procedure sp_test (
In P1 bigint,
In P2 char (64 ),
In P3 char (16)
)
Begin
-- Do somethings
End;

2. variables-define variables
Declare _ id int default 0;
-- Assign a value to the variable (Note: This method will automatically convert the data type)
Select 'id' into _ id from 'table' where 'id' = 1;
-- Assign values to variables (Note: This method does not automatically convert data types)
Set _ id = 1;
Select _ id = 1;

3. Process Control-ifelse
If 1 = 1 then
-- SQL 1;
Else
-- SQL 2
End if;

-- While
Drop procedure if exists test1;
Create procedure test1 ()
Begin
Declare I int default 1;
While I <= 100 do
Insert into rank_curr (rank_id, mbr_id, rank_val, rank_num)
Values
(1, 10000 + I,-I, I );
Set I = I + 1;
End while;
End;
Call test1;