Assign values to user-defined variables. This guide explains how to store data in session-specific variables for reuse in subsequent SQL statements.
SET var_name = expr [, var_name = expr] ...The SET statement in is an extended version of the general statement. Referenced variables may be ones declared inside a stored program, global system variables, or user-defined variables.
The SET statement in stored programs is implemented as part of the pre-existing syntax. This allows an extended syntax of SET a=x, b=y, ... where different variable types (locally declared variables, global and session server variables, user-defined variables) can be mixed. This also allows combinations of local variables and some options that make sense only for system variables; in that case, the options are recognized but ignored.
SET can be used with both and .
When setting several variables using the columns returned by a query, should be preferred.
To set many variables to the same value, the function can be used.
Below is an example of how a user-defined variable may be set:
This page is licensed: GPLv2, originally from
SET @x = 1;