MENU


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.