SHOW BINARY LOGS Syntax SHOW BINARY LOGS; SHOW MASTER LOGS; SHOW BINLOG EVENTS Syntax SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] SHOW CHARACTER SET Syntax SHOW CHARACTER SET [LIKE 'pattern' | WHERE expr] SHOW COLLATION Syntax SHOW COLLATION [like_or_where] SHOW COLUMNS Syntax SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where] SHOW CONTRIBUTORS Syntax SHOW CONTRIBUTORS SHOW CREATE DATABASE Syntax SHOW CREATE DATABASE db_name SHOW CREATE EVENT Syntax SHOW CREATE EVENT event_name SHOW CREATE FUNCTION Syntax SHOW CREATE FUNCTION func_name SHOW CREATE PROCEDURE Syntax SHOW CREATE PROCEDURE proc_name SHOW CREATE TABLE Syntax SHOW CREATE TABLE tbl_name SHOW CREATE TRIGGER Syntax SHOW CREATE TRIGGER trigger_name SHOW CREATE VIEW Syntax SHOW CREATE VIEW view_name SHOW DATABASES Syntax SHOW DATABASES [like_or_where] SHOW ENGINE Syntax SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINES Syntax SHOW [STORAGE] ENGINES SHOW ERRORS Syntax SHOW ERRORS [LIMIT [offset,] row_count] SHOW EVENTS Syntax SHOW EVENTS SHOW FUNCTION CODE Syntax SHOW FUNCTION CODE func_name SHOW FUNCTION STATUS Syntax SHOW FUNCTION STATUS [like_or_where] SHOW GRANTS Syntax SHOW GRANTS FOR user SHOW INDEX Syntax SHOW INDEX FROM tbl_name [FROM db_name] SHOW INNODB STATUS Syntax SHOW INNODB STATUS SHOW MASTER STATUS Syntax SHOW MASTER STATUS SHOW OPEN TABLES Syntax SHOW OPEN TABLES [FROM db_name] [like_or_where] SHOW PLUGINS Syntax SHOW PLUGINS SHOW PRIVILEGES Syntax SHOW PRIVILEGES SHOW PROCEDURE CODE Syntax SHOW PROCEDURE CODE proc_name SHOW PROCEDURE STATUS Syntax SHOW PROCEDURE STATUS [like_or_where] SHOW PROCESSLIST Syntax SHOW [FULL] PROCESSLIST SHOW PROFILE Syntax SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n] SHOW PROFILES Syntax SHOW PROFILES SHOW SCHEDULER STATUS Syntax SHOW SCHEDULER STATUS SHOW SLAVE HOSTS Syntax SHOW SLAVE HOSTS SHOW SLAVE STATUS Syntax SHOW SLAVE STATUS SHOW STATUS Syntax SHOW [GLOBAL | SESSION] STATUS [like_or_where] SHOW TABLE STATUS Syntax SHOW TABLE STATUS [FROM db_name] [like_or_where] SHOW TABLES Syntax SHOW [FULL] TABLES [FROM db_name] [like_or_where] SHOW TRIGGERS Syntax SHOW TRIGGERS [FROM db_name] [like_or_where] SHOW VARIABLES Syntax SHOW [GLOBAL | SESSION] VARIABLES [like_or_where] SHOW WARNINGS Syntax SHOW WARNINGS [LIMIT [offset,] row_count]