MySQL 5.0 stored Procedure Learning Summary

I. Creating a stored Procedure

1. Basic grammar:

CREATE PROCEDURE Sp_name ()

Begin

.........

End

2. Parameter transfer

Two. Call the stored procedure

1. Basic syntax: Call Sp_name ()

Note: The stored procedure name must be followed by parentheses, even if the stored procedure has no parameter passing

Three. Delete stored procedures

1. Basic grammar:

drop procedure sp_name//

2. Matters needing attention

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

Four. blocks, conditions, loops

1. Block definition, commonly used

Begin

......

End

You can also alias a block, such as:

Lable:begin

...........

End lable;

You can use leave lable to jump out of blocks and execute code after blocks

2. Conditional statement

以下为引用的内容：
if 条件 then
statement
else
statement
end if;