(mysql.info.gz) BEGIN END
Info Catalog
(mysql.info.gz) CALL
(mysql.info.gz) Stored Procedure Syntax
(mysql.info.gz) DECLARE
19.1.4 `BEGIN ... END' Compound Statement
-----------------------------------------
[BEGIN_LABEL:] BEGIN
[STATEMENT_LIST]
END [END_LABEL]
Stored routines may contain multiple statements, using a `BEGIN ...
END' compound statement.
BEGIN_LABEL and END_LABEL must be the same, if both are specified.
Please note that the optional `[NOT] ATOMIC' clause is not yet
supported. This means that no transactional savepoint is set at the
start of the instruction block and the `BEGIN' clause used in this
context has no effect on the current transaction.
Using multiple statements requires that a client is able to send query
strings containing the `;' statement delimiter. This is handled in the
`mysql' command-line client with the `delimiter' command. Changing the
`;' end-of-query delimiter (for example, to `//') allows `;' to be used
in a routine body.
Info Catalog
(mysql.info.gz) CALL
(mysql.info.gz) Stored Procedure Syntax
(mysql.info.gz) DECLARE
automatically generated byinfo2html