SHOW

SHOW BINARY LOGS SHOW MASTER LOGS	These list the log files on the server and the sizes.
SHOW BINLOG EVENTS [IN ‘log_name’] [FROM pos] [LIMIT [offset,] row_count]	This shows the events in the binary log. If ‘log_name’ is not specified, the first binary log is used.
SHOW CHARACTER SET [LIKE ‘pattern’ \| WHERE expr]	This shows all available character sets.
SHOW COLLATION [LIKE ‘pattern’ \| WHERE expr]	This lists collations supported by the server.
SHOW [FULL] COLUMNS {FROM \| IN} tbl [{FROM\|IN} db] [LIKE ‘pattern’ \| WHERE expr]	This displays information about the columns in a table.
SHOW CREATE {DATABASE\|SCHEMA} [IF NOT EXISTS] db	This shows the statement that creates the database.
SHOW CREATE EVENT event	This displays the statement that creates an event.
SHOW CREATE FUNCTION function	This displays the statement that defines a function.
SHOW CREATE PROCEDURE procedure	This displays the statement that creates a stored procedure.
SHOW CREATE TABLE tbl	This displays the statement that creates a table.
SHOW CREATE TRIGGER trigger	This displays the statement that creates a trigger.
SHOW CREATE VIEW view	This displays the statement that creates a view.
SHOW {DATABASES \| SCHEMAS} [LIKE ‘pattern’ \| WHERE expr]	This lists the databases on the server.
SHOW ENGINE engine {STATUS \| MUTEX}	This displays the operational information about a storage engine.
SHOW [STORAGE] ENGINES	This displays information about the server’s storage engines.
SHOW ERRORS [LIMIT [offset,] row_count] SHOW COUNT(*) ERRORS	These display information about errors resulting from executing a statement in the current session.
SHOW EVENTS [{FROM \| IN} schema] [LIKE ‘pattern’ \| WHERE expr]	This displays information about Event Manager events.
SHOW FUNCTION CODE function	This displays a representation of the internal implementation of the function.
SHOW FUNCTION STATUS [LIKE ‘pattern’ \| WHERE expr]	This shows the characteristics of a function.
SHOW GRANTS [FOR user]	This lists the statement that can be used to duplicate the privileges granted to an account.
SHOW {INDEX \| INDEXES \| KEYS} {FROM\|IN} tbl [{FROM\|IN} db] [WHERE expr]	This displays information about the indexes in a table.
SHOW MASTER STATUS	This displays status information about the binary log files of the master.
SHOW OPEN TABLES [{FROM\|IN} db] [LIKE ‘pattern’\| WHERE expr]	This lists the non-temporary tables that are currently open in the table cache.
SHOW PLUGINS	This displays information about server plugins.
SHOW PRIVILEGES	This lists the supported system privileges.
SHOW PROCEDURE CODE procedure	This displays a representation of the internal implementation of the stored procedure.
SHOW PROCEDURE STATUS [LIKE ‘pattern’ \| WHERE expr]	This displays the chraracteristics about a stored procedure.
SHOW PROCESSLIST	This displays which threads are running.
SHOW RELAYLOG EVENTS [IN ‘log_name’] [FROM pos] [LIMIT [offset,] row_count]	This shows the events in the relay log of a replication slave.
SHOW SLAVE HOSTS	This displays a list of replication slaves currently registered with the master.
SHOW SLAVE STATUS [NONBLOCKING]	This provides status information on essential parameters of the slave threads.
SHOW [GLOBAL\|SESSION] STATUS [LIKE ‘pattern’ \| WHERE expr]	This provides server status information.
SHOW TABLE STATUS [{FROM\|IN} db] [LIKE ‘pattern’ \| WHERE expr]	This works like ‘SHOW TABLES’, but provides a lot of information about each non-TEMPORARY table.
SHOW TRIGGERS [{FROM\|IN} db] [LIKE ‘pattern’ \| WHERE expr]	This lists the triggers currently defined for the tables in a database.
SHOW [GLOBAL\|SESSION] VARIABLES [LIKE ‘pattern’ \| WHERE expr]	This shows the values of the system variables.
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS	This displays information about the errors, warnings and notes resulting from a statement in the current session.

MENU

SHOW