(mysql.info) declare

Info Catalog

(mysql.info) begin-end

(mysql.info) stored-procedure-syntax

(mysql.info) variables-in-stored-procedures

 
 17.2.6 `DECLARE' Statement Syntax
 ---------------------------------
 
 The `DECLARE' statement is used to define various items local to a
 routine:
 
    * Local variables. See  variables-in-stored-procedures.
 
    * Conditions and handlers. See  conditions-and-handlers.
 
    * Cursors. See  cursors.
 
 The `SIGNAL' and `RESIGNAL' statements are not currently supported.
 
 `DECLARE' is allowed only inside a `BEGIN ... END' compound statement
 and must be at its start, before any other statements.
 
 Declarations must follow a certain order. Cursors must be declared
 before declaring handlers, and variables and conditions must be
 declared before declaring either cursors or handlers.
 

Info Catalog

(mysql.info) begin-end

(mysql.info) stored-procedure-syntax

(mysql.info) variables-in-stored-procedures