Information Schema GLOBAL_VARIABLES and SESSION_VARIABLES Tables
The Information Schema GLOBAL_VARIABLES
and SESSION_VARIABLES
tables stores a record of all system variables and their global and session values respectively. This is the same information as displayed by the [SHOW VARIABLES](../../../show/show-variables.md)
commands SHOW GLOBAL VARIABLES
and SHOW SESSION VARIABLES
.
It contains the following columns:
Column
Description
Column
Description
VARIABLE_NAME
System variable name.
VARIABLE_VALUE
Global or session value.
Example
This page is licensed: CC BY-SA / Gnu FDL
PreviousInformation Schema GLOBAL_STATUS and SESSION_STATUS TablesNextInformation Schema INDEX_STATISTICS Table
Last updated
Was this helpful?