SHOW PARAMETERS command¶
The SHOW PARAMETERS command lists all the parameters in the current session.
For more information about how to set parameters, see SESSION SET.
Syntax¶
- show_parameters_command
show_parameters_command ::=
'SHOW' 'PARAMETERS'
Examples¶
Show all parameters¶
# Create two parameters
SESSION SET VALUE $param1 = 10
SESSION SET VALUE $param2 = 20
# Show parameters
SHOW PARAMETERS
Return:
+----------------+-----------------+
| parameter_name | parameter_value |
+----------------+-----------------+
| param2 | 20 |
| param1 | 10 |
+----------------+-----------------+