Easy access to the "MySQL" database stored procedure _ MySQL

Easy access to the "MySQL" database stored procedure 1. create a stored procedure

1. basic syntax:

Create procedure sp_name ()

Begin

.........

End

2. parameter transfer

II. call the stored procedure

1. basic syntax: call sp_name ()

Note: the stored procedure name must be enclosed in parentheses, even if the stored procedure has no parameters

III. delete stored procedures

1. basic syntax:

Drop procedure sp_name //

2. Notes

(1) you cannot delete another stored procedure in one stored procedure. you can only call another stored procedure.

4. blocks, conditions, and loops

1. Block definition, commonly used

Begin

......

End;

You can also create an alias for the block, such:

Lable: begin

...........

End lable;

You can use leave lable to jump out of the block and execute code after the block.