(mysql.info.gz) DECLARE

Info Catalog

(mysql.info.gz) BEGIN END

(mysql.info.gz) Stored Procedure Syntax

(mysql.info.gz) Variables in Stored Procedures

 
 19.1.5 `DECLARE' Statement
 --------------------------
 
 The `DECLARE' statement is used to define various items local to a
 routine: local variables ( Variables in Stored Procedures),
 conditions and handlers ( Conditions and Handlers) and cursors
 ( Cursors).  `SIGNAL' and `RESIGNAL' statements are not
 currently supported.
 
 `DECLARE' may be used only inside a `BEGIN ... END' compound statement
 and must be at its start, before any other statements.
 
 Cursors must be declared before declaring handlers, and variables must
 be declared before declaring either cursors or handlers.
 

Info Catalog

(mysql.info.gz) BEGIN END

(mysql.info.gz) Stored Procedure Syntax

(mysql.info.gz) Variables in Stored Procedures