SHOW

SHOW CHARACTER SET [LIKE 'maska' | WHERE 'podmínka']
SHOW COLLATION [LIKE 'maska' | WHERE 'podmínka']
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'maska' | WHERE 'podmínka']
SHOW CREATE DATABASE jmeno_databaze
SHOW CREATE FUNCTION jmeno_funkce
SHOW CREATE PROCEDURE jmeno_procedury
SHOW CREATE TABLE jmeno_tabulky
SHOW DATABASES [LIKE 'maska' | WHERE 'podmínka']
SHOW ENGINE engine_name {LOGS | STATUS }
SHOW [STORAGE] ENGINES
SHOW ERRORS [LIMIT [offset,] row_count]
SHOW FUNCTION CODE sp_name
SHOW FUNCTION STATUS [LIKE 'maska' | WHERE 'podmínka']
SHOW GRANTS FOR user
SHOW INDEX FROM jmeno_tabulky [FROM jmeno_databaze]
SHOW INNODB STATUS
SHOW PROCEDURE CODE jmeno_ulozene_procedury
SHOW PROCEDURE STATUS [LIKE 'maska' | WHERE 'podmínka']
SHOW [BDB] LOGS
SHOW MUTEX STATUS
SHOW OPEN TABLES [FROM jmeno_databaze] [LIKE 'maska' | WHERE 'podmínka']
SHOW PRIVILEGES
SHOW [FULL] PROCESSLIST
SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]
SHOW PROFILES
SHOW [GLOBAL | SESSION] STATUS [LIKE 'maska' | WHERE 'podmínka']
SHOW TABLE STATUS [FROM jmeno_databaze] [LIKE 'maska' | WHERE 'podmínka']
SHOW TABLES [FROM jmeno_databaze] [LIKE 'maska' | WHERE 'podmínka']
SHOW TRIGGERS [FROM jmeno_databaze] [LIKE 'maska' | WHERE 'podmínka']
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'maska' | WHERE 'podmínka']
SHOW WARNINGS [LIMIT [offset,] row_count]