Articles on the various SHOW commands.
-
About SHOW
Description: SHOW has many forms that provide information about databases, ... -
SHOW AUTHORS
Syntax: SHOW AUTHORSDescription: The SHOW AUTHORS statement displays inform... -
SHOW BINARY LOGS
Syntax: SHOW BINARY LOGS SHOW MASTER LOGSDescription: Lists the binary log ... -
SHOW BINLOG EVENTS
Syntax: SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] r... -
SHOW CHARACTER SET
Syntax: SHOW CHARACTER SET [LIKE 'pattern' | WHERE expr]Description: Th... -
SHOW COLLATION
Syntax: SHOW COLLATION [LIKE 'pattern' | WHERE expr]Description: The ou... -
SHOW COLUMNS
Syntax: SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern... -
SHOW CONTRIBUTORS
Syntax: SHOW CONTRIBUTORS Description: The SHOW CONTRIBUTORS statement disp... -
SHOW CREATE DATABASE
Syntax: SHOW CREATE {DATABASE | SCHEMA} db_nameDescription: Shows the CREAT... -
SHOW CREATE EVENT
Syntax: SHOW CREATE EVENT event_name Description: This statement displays... -
SHOW CREATE FUNCTION
Syntax: SHOW CREATE FUNCTION func_nameDescription: This statement is simila... -
SHOW CREATE PROCEDURE
Syntax: SHOW CREATE PROCEDURE proc_nameDescription: This statement is a Mar... -
SHOW CREATE TABLE
Syntax: SHOW CREATE TABLE tbl_nameDescription: Shows the CREATE TABLE state... -
SHOW CREATE TRIGGER
Syntax: SHOW CREATE TRIGGER trigger_nameDescription: This statement shows a... -
SHOW CREATE VIEW
Syntax: SHOW CREATE VIEW view_nameDescription: This statement shows a CREAT... -
SHOW DATABASES
Syntax: SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr]Descrip... -
SHOW ENGINE
Syntax: SHOW ENGINE engine_name {STATUS | MUTEX}Description: SHOW ENGINE di... -
SHOW ENGINES
Syntax: SHOW [STORAGE] ENGINESDescription: SHOW ENGINES displays status inf... -
SHOW ERRORS
Syntax: SHOW ERRORS [LIMIT [offset,] row_count] SHOW COUNT(*) ERRORSDescrip... -
SHOW EVENTS
Syntax: SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE e... -
SHOW FUNCTION CODE
Syntax: SHOW FUNCTION CODE func_nameDescription: This statement is similar ... -
SHOW FUNCTION STATUS
Syntax: SHOW FUNCTION STATUS [LIKE 'pattern' | WHERE expr]Description: ... -
SHOW GRANTS
Syntax SHOW GRANTS [FOR user]Description This statement lists the GRANT sta... -
SHOW INDEX
Syntax: SHOW INDEX FROM tbl_name [FROM db_name]Description: SHOW INDEX retu... -
SHOW INNODB STATUS
Syntax: SHOW INNODB STATUSDescription: In MariaDB, this is a deprecated syn... -
SHOW MASTER STATUS
Syntax: SHOW MASTER STATUSDescription: Provides status information about th... -
SHOW OPEN TABLES
Syntax: SHOW OPEN TABLES [FROM db_name] [LIKE 'pattern' | WHERE expr]De... -
SHOW PLUGINS
Syntax: SHOW PLUGINS;Description: SHOW PLUGINS displays information about ... -
SHOW PRIVILEGES
Syntax: SHOW PRIVILEGESDescription: SHOW PRIVILEGES shows the list of syst... -
SHOW PROCEDURE CODE
Syntax: SHOW PROCEDURE CODE proc_nameDescription: This statement is a Maria... -
SHOW PROCEDURE STATUS
Syntax: SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr]Description:... -
SHOW PROCESSLIST
Syntax: SHOW [FULL] PROCESSLISTDescription: SHOW PROCESSLIST shows you whi... -
SHOW PROFILE
Syntax: SHOW PROFILESDescription: The SHOW PROFILE statement display profil... -
SHOW PROFILES
Syntax: SHOW PROFILE [type [, type] ... ] [FOR QUERY n] [LIMIT row_count [OFFSET of -
SHOW SLAVE HOSTS
Syntax: SHOW SLAVE HOSTSDescription: Displays a list of replication slaves ... -
SHOW SLAVE STATUS
Syntax: SHOW SLAVE STATUSDescription: This statement provides status inform... -
SHOW STATUS
Syntax: SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr]Des... -
SHOW TABLE STATUS
Syntax: SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern' | WHERE expr]D... -
SHOW TABLES
Syntax: SHOW [FULL] TABLES [FROM db_name] [LIKE 'pattern' | WHERE expr]... -
SHOW TRIGGERS
Syntax: SHOW TRIGGERS [FROM db_name] [LIKE 'pattern' | WHERE expr]Descr... -
SHOW VARIABLES
Syntax: SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr]... -
SHOW WARNINGS
Syntax: SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGSDes...
