Search Results
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-option-variable-reference.html
This table provides an overview of the command options, system variables, and status variables provided by X Plugin.
https://dev.mysql.com/doc/refman/8.4/en/stored-program-variables.html
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 DECLARE to define local variables, and stored routines (procedures and ...INTO ...
https://dev.mysql.com/doc/internals/en/custom-engine-variables-and-parameters.html
For more information on adding system variables, status variables, and options supported on the command line or configuration file, see Section 5.5, “Specifying mysqld Variables Within a Plugin”.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-option-variable-reference.html
Table 29.16 Performance Schema Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic performance_schema Yes Yes Yes Global No Performance_schema_accounts_lost Yes Global No performance_schema_accounts_size Yes Yes Yes ...
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. User variables are written as @var_name, where the variable name var_name consists of alphanumeric characters, ., _, and $. A user ...This ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. Because local variables are in scope only during stored ...
https://dev.mysql.com/doc/refman/8.4/en/declare-local-variable.html
type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. Local variables are treated like stored routine parameters with respect to data type and ...The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 11.4, “User-Defined Variables”. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is ...
https://dev.mysql.com/doc/refman/8.4/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-variables.html
time_zone and timestamp variable settings are not passed to MySQL HeatWave when queries are offloaded.