MySQL AB :: MySQL 5.1 Reference Manual :: 18.2.7 Variables in Stored Routines

DEVELOPER ZONE ::

Login / Register

Home
Products
Services
Partners
Community
Customers
News & Events
About
Why MySQL?
How to Buy

Documentation
- MySQL 5.1 Reference Manual
  - 5.1
  - 5.0
  - 3.23, 4.0, 4.1

Search manual:

Additional languages

German

MySQL 5.1 Reference Manual :: 18 Stored Procedures and Functions :: 18.2 Stored Routine Syntax :: 18.2.7 Variables in Stored Routines

« 18.2.6 DECLARE Statement Syntax

18.2.7.1 DECLARE Local Variables »

Section Navigation [Toggle]

18.2 Stored Routine Syntax
18.2.1 CREATE PROCEDURE and CREATE FUNCTION Syntax
18.2.2 ALTER PROCEDURE and ALTER FUNCTION Syntax
18.2.3 DROP PROCEDURE and DROP FUNCTION Syntax
18.2.4 CALL Statement Syntax
18.2.5 BEGIN ... END Compound Statement Syntax
18.2.6 DECLARE Statement Syntax
18.2.7 Variables in Stored Routines
18.2.8 Conditions and Handlers
18.2.9 Cursors
18.2.10 Flow Control Constructs

18.2.7. Variables in Stored Routines

18.2.7.1. DECLARE Local Variables
18.2.7.2. Variable SET Statement
18.2.7.3. SELECT ... INTO Statement

You may declare and use variables within a routine.

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

© 1995-2007 MySQL AB. All rights reserved.

Online Shop
Site Map
Legal
Contact Us
Careers