MySQL stored procedures

1.1 Creating a stored procedure

In MySQL, the basic form of creating stored procedures is as follows:

1. CREATE PROCEDURE sp_name ([proc_parameter[,...]])
2. [Characteristic ...] Routine_body

Where the Sp_name parameter is the name of the stored procedure, Proc_parameter represents the parameter list of the stored procedure, the characteristic parameter specifies the properties of the stored procedure, the Routine_body parameter is the contents of the SQL code, you can use the BEGIN ... End to flag the start and end of the SQL code.

Each parameter in the Proc_parameter is made up of 3 parts. These 3 sections are input and output types, parameter names, and parameter types, respectively. The form is as follows:

1. [In | Out | INOUT] Param_name Type

MySQL stored procedures