Mysql advanced storage process

Mysql advanced storage process

Similar to a function, a piece of code is encapsulated. to execute this piece of code, you can call this stored procedure. in the encapsulated statement body, you can use the if/else, case, while and other control structures. SQL programming is supported.

In mysql, what are the differences between stored procedures and functions,

One is with different names,

There is no return value for the stored procedure.

What if I want to obtain the return value? The out variable is OK!

View existing stored procedures:

Show procedure status

 

Delete stored procedure

Name of the Drop procedure Stored procedure

 

Call Stored Procedure

Call stored procedure name ();

1. Declare variables in the process

2 variables involved in calculation and simple control statements

3. Pass parameters to the stored procedure

4 while LOOP

5. Output Variables

6 switch statements

7. do while statement