W3cubDocs

SHOW

Articles on the various SHOW commands.

Title	Description
About SHOW	General information about the SHOW statement.
Extended Show	Extended SHOW with WHERE and LIKE.
SHOW AUTHORS	Information about the people who work on MariaDB.
SHOW BINARY LOGS	SHOW BINARY LOGS lists all binary logs on the server.
SHOW BINLOG EVENTS	Show events in the binary log
SHOW CHARACTER SET	Available character sets.
SHOW CLIENT_STATISTICS	Statistics about client connections
SHOW COLLATION	Supported collations.
SHOW COLUMNS	Column information.
SHOW CONTRIBUTORS	Companies and people who financially contribute to MariaDB.
SHOW CREATE DATABASE	Shows the CREATE DATABASE statement that created the database
SHOW CREATE EVENT	Displays the CREATE EVENT statement needed to re-create a given event
SHOW CREATE FUNCTION	Statement that created the function
SHOW CREATE PACKAGE	Show the CREATE statement that creates the given package specification.
SHOW CREATE PACKAGE BODY	Show the CREATE statement that creates the given package body (i.e. implementation).
SHOW CREATE PROCEDURE	Returns the string used for creating a stored procedure.
SHOW CREATE SEQUENCE	Shows the CREATE SEQUENCE statement that created the sequence.
SHOW CREATE TABLE	Shows the CREATE TABLE statement that created the table.
SHOW CREATE TRIGGER	Shows the CREATE TRIGGER statement used to create the trigger
SHOW CREATE USER	Show the CREATE USER statement for a specified user.
SHOW CREATE VIEW	Show the CREATE VIEW statement that created a view
SHOW DATABASES	Lists the databases on the server
SHOW ENGINE	Show storage engine information
SHOW ENGINE INNODB STATUS	Display extensive InnoDB information.
SHOW ENGINES	Server storage engine info
SHOW ERRORS	Displays errors.
SHOW EVENTS	Shows information about events
SHOW EXPLAIN	Shows an execution plan for a running query
SHOW FUNCTION CODE	Representation of the internal implementation of the stored function
SHOW FUNCTION STATUS	Stored function characteristics
SHOW GRANTS	View GRANT statements.
SHOW INDEX	Information about table indexes
SHOW INDEX_STATISTICS	Index usage statistics
SHOW INNODB STATUS (removed)	Removed synonym for SHOW ENGINE INNODB STATUS
SHOW LOCALES	View locales information
SHOW MASTER STATUS	Status information about the binary log.
SHOW OPEN TABLES	List non-temporary open tables.
SHOW PACKAGE BODY STATUS	Returns characteristics of stored package bodies (implementations).
SHOW PACKAGE STATUS	Returns characteristics of stored package specifications.
SHOW PLUGINS	Display information about installed plugins.
SHOW PLUGINS SONAME	Information about all available plugins, installed or not
SHOW PRIVILEGES	Shows the list of supported system privileges.
SHOW PROCEDURE CODE	Display internal implementation of a stored procedure.
SHOW PROCEDURE STATUS	Stored procedure characteristics.
SHOW PROCESSLIST	Running threads and information about them
SHOW PROFILE	Display statement resource usage
SHOW PROFILES	Show statement resource usage
SHOW QUERY_RESPONSE_TIME	Retrieving information from the QUERY_RESPONSE_TIME plugin
SHOW RELAYLOG EVENTS	Show events in the relay log
SHOW SLAVE HOSTS	Display replication slaves currently registered with the master.
SHOW SLAVE STATUS	Show status for one or all masters.
SHOW STATUS	Server status information.
SHOW TABLE STATUS	SHOW TABLES with information about non-temporary tables
SHOW TABLES	List of non-temporary tables, views or sequences.
SHOW TABLE_STATISTICS	Table usage statistics
SHOW TRIGGERS	Shows currently-defined triggers
SHOW USER_STATISTICS	User activity statistics
SHOW VARIABLES	Displays the values of system variables.
SHOW WARNINGS	Displays errors, warnings and notes.
SHOW WSREP_MEMBERSHIP	Galera node cluster membership information
SHOW WSREP_STATUS	Galera node cluster status information

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show/