Movatterモバイル変換

MySQL 9.2 Reference Manual

15.6.4 Variables in Stored Programs

15.6.4.1 Local Variable DECLARE Statement
15.6.4.2 Local Variable Scope and Resolution

System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can useDECLARE to define local variables, and stored routines (procedures and functions) can be declared to take parameters that communicate values between the routine and its caller.

To declare local variables, use theDECLARE statement, as described inSection 15.6.4.1, “Local Variable DECLARE Statement”.
Variables can be set directly with theSET statement. SeeSection 15.7.6.1, “SET Syntax for Variable Assignment”.
Results from queries can be retrieved into local variables usingSELECT ... INTOvar_list or by opening a cursor and usingFETCH ... INTOvar_list. SeeSection 15.2.13.1, “SELECT ... INTO Statement”, andSection 15.6.6, “Cursors”.

For information about the scope of local variables and how MySQL resolves ambiguous names, seeSection 15.6.4.2, “Local Variable Scope and Resolution”.

It is not permitted to assign the valueDEFAULT to stored procedure or function parameters or stored program local variables (for example with aSETvar_name = DEFAULT statement). In MySQL 9.2, this results in a syntax error.

PREV HOME UP NEXT