(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