MySQL的show命令
原文来自:http://dev.mysql.com/doc/refman/5.5/en/show.html
12.4.5.2. SHOW BINARY LOGS Syntax
12.4.5.3. SHOW BINLOG EVENTS Syntax
12.4.5.4. SHOW CHARACTER SET Syntax
12.4.5.5. SHOW COLLATION Syntax
12.4.5.7. SHOW CONTRIBUTORS Syntax
12.4.5.8. SHOW CREATE DATABASE Syntax
12.4.5.9. SHOW CREATE EVENT Syntax
12.4.5.10. SHOW CREATE FUNCTION Syntax
12.4.5.11. SHOW CREATE PROCEDURE Syntax
12.4.5.12. SHOW CREATE TABLE Syntax
12.4.5.13. SHOW CREATE TRIGGER Syntax
12.4.5.14. SHOW CREATE VIEW Syntax
12.4.5.15. SHOW DATABASES Syntax
12.4.5.17. SHOW ENGINES Syntax
12.4.5.20. SHOW FUNCTION CODE Syntax
12.4.5.21. SHOW FUNCTION STATUS Syntax
12.4.5.24. SHOW MASTER STATUS Syntax
12.4.5.25. SHOW OPEN TABLES Syntax
12.4.5.26. SHOW PLUGINS Syntax
12.4.5.27. SHOW PRIVILEGES Syntax
12.4.5.28. SHOW PROCEDURE CODE Syntax
12.4.5.29. SHOW PROCEDURE STATUS Syntax
12.4.5.30. SHOW PROCESSLIST Syntax
12.4.5.31. SHOW PROFILE Syntax
12.4.5.32. SHOW PROFILES Syntax
12.4.5.33. SHOW RELAYLOG EVENTS Syntax
12.4.5.34. SHOW SLAVE HOSTS Syntax
12.4.5.35. SHOW SLAVE STATUS Syntax
12.4.5.37. SHOW TABLE STATUS Syntax
12.4.5.39. SHOW TRIGGERS Syntax
12.4.5.40. SHOW VARIABLES Syntax
12.4.5.41. SHOW WARNINGS Syntax
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. This section describes those following:
SHOW AUTHORS
SHOW {BINARY | MASTER} LOGS
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
SHOW CHARACTER SET [like_or_where]
SHOW COLLATION [like_or_where]
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]
SHOW CONTRIBUTORS
SHOW CREATE DATABASE db_name
SHOW CREATE EVENT event_name
SHOW CREATE FUNCTION func_name
SHOW CREATE PROCEDURE proc_name
SHOW CREATE TABLE tbl_name
SHOW CREATE TRIGGER trigger_name
SHOW CREATE VIEW view_name
SHOW DATABASES [like_or_where]
SHOW ENGINE engine_name {STATUS | MUTEX}
SHOW [STORAGE] ENGINES
SHOW ERRORS [LIMIT [offset,] row_count]
SHOW EVENTS
SHOW FUNCTION CODE func_name
SHOW FUNCTION STATUS [like_or_where]
SHOW GRANTS FOR user
SHOW INDEX FROM tbl_name [FROM db_name]
SHOW MASTER STATUS
SHOW OPEN TABLES [FROM db_name] [like_or_where]
SHOW PLUGINS
SHOW PROCEDURE CODE proc_name
SHOW PROCEDURE STATUS [like_or_where]
SHOW PRIVILEGES
SHOW [FULL] PROCESSLIST
SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]
SHOW PROFILES
SHOW SLAVE HOSTS
SHOW SLAVE STATUS
SHOW [GLOBAL | SESSION] STATUS [like_or_where]
SHOW TABLE STATUS [FROM db_name] [like_or_where]
SHOW [FULL] TABLES [FROM db_name] [like_or_where]
SHOW TRIGGERS [FROM db_name] [like_or_where]
SHOW [GLOBAL | SESSION] VARIABLES [like_or_where]
SHOW WARNINGS [LIMIT [offset,] row_count]
like_or_where:
LIKE 'pattern'
| WHERE expr