|
SHOW
There are following SHOW statements available:
|
Parameter
|
Available options
|
version of MySQL server
|
|
SHOW PROCESSLIST
|
|
|
|
SHOW STATUS
|
LIKE pattern - as of MySQL 3.23.00
|
|
|
SHOW VARIABLES
|
LIKE pattern
|
3.22.00
|
|
TABLE STATUS
|
FROM database, LIKE pattern
|
3.23.0
|
|
LOGS
|
|
3.23.29
|
|
OPEN TABLES
|
|
3.23.33
|
|
INNODB STATUS
|
|
3.23.52
|
|
SESSION VARIABLES
|
LIKE pattern
|
4.0.3
|
|
GLOBAL VARIABLES
|
LIKE pattern
|
4.0.3
|
|
CHARACTER SET
|
|
4.1
|
|
COLUMN TYPE
|
|
4.1
|
|
TABLE TYPE
|
|
4.1
|
|
PRIVILEGES
|
|
4.1
|
Such parameters as LIKE pattern, FROM database are used when applicable,
The items are shown in the pulldown menu only if they are supported by current version of Mysql Server.
|
