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 use
define local variables, and stored routines (procedures and
functions) can be declared to take parameters that communicate
values between the routine and its caller.
Results from queries can be retrieved into local variables
INTO or by
opening a cursor and using
FETCH ... INTO
Section 126.96.36.199, “SELECT ... INTO Syntax”, and Section 13.6.6, “Cursors”.
For information about the scope of local variables and how MySQL resolves ambiguous names, see Section 188.8.131.52, “Local Variable Scope and Resolution”.
It is not permitted to assign the value
to stored procedure or function parameters or stored program local
variables (for example with a
statement). In MySQL 5.7, this results in a syntax
var_name = DEFAULT