MySQL Tutorial/Procedure Function/Begin End

BEGIN and END Statements

BEGIN and END statements group statements in procedures with more than one SQL statement.

Declarations can be made only within a BEGIN ... END block.

You can define a label for the block to clarify your code.

The labels must match exactly.

yourLableName: BEGIN
<SQL statement>;
<SQL statement>;
END yourLableName