MySQL SHOW Syntax

「爱情、让人受尽委屈。」 2022-09-29 05:27 151阅读 0赞

**MySQL的show命令**

原文来自：[http://dev.mysql.com/doc/refman/5.5/en/show.html][http_dev.mysql.com_doc_refman_5.5_en_show.html]

**12.4.5. ****SHOW** **Syntax**

[12.4.5.1. **SHOW AUTHORS** Syntax][12.4.5.1. _SHOW AUTHORS_ Syntax]

[12.4.5.2. **SHOW BINARY LOGS** Syntax][12.4.5.2. _SHOW BINARY LOGS_ Syntax]

[12.4.5.3. **SHOW BINLOG EVENTS** Syntax][12.4.5.3. _SHOW BINLOG EVENTS_ Syntax]

[12.4.5.4. **SHOW CHARACTER SET** Syntax][12.4.5.4. _SHOW CHARACTER SET_ Syntax]

[12.4.5.5. **SHOW COLLATION** Syntax][12.4.5.5. _SHOW COLLATION_ Syntax]

[12.4.5.6. **SHOW COLUMNS** Syntax][12.4.5.6. _SHOW COLUMNS_ Syntax]

[12.4.5.7. **SHOW CONTRIBUTORS** Syntax][12.4.5.7. _SHOW CONTRIBUTORS_ Syntax]

[12.4.5.8. **SHOW CREATE DATABASE** Syntax][12.4.5.8. _SHOW CREATE DATABASE_ Syntax]

[12.4.5.9. **SHOW CREATE EVENT** Syntax][12.4.5.9. _SHOW CREATE EVENT_ Syntax]

[12.4.5.10. **SHOW CREATE FUNCTION** Syntax][12.4.5.10. _SHOW CREATE FUNCTION_ Syntax]

[12.4.5.11. **SHOW CREATE PROCEDURE** Syntax][12.4.5.11. _SHOW CREATE PROCEDURE_ Syntax]

[12.4.5.12. **SHOW CREATE TABLE** Syntax][12.4.5.12. _SHOW CREATE TABLE_ Syntax]

[12.4.5.13. **SHOW CREATE TRIGGER** Syntax][12.4.5.13. _SHOW CREATE TRIGGER_ Syntax]

[12.4.5.14. **SHOW CREATE VIEW** Syntax][12.4.5.14. _SHOW CREATE VIEW_ Syntax]

[12.4.5.15. **SHOW DATABASES** Syntax][12.4.5.15. _SHOW DATABASES_ Syntax]

[12.4.5.16. **SHOW ENGINE** Syntax][12.4.5.16. _SHOW ENGINE_ Syntax]

[12.4.5.17. **SHOW ENGINES** Syntax][12.4.5.17. _SHOW ENGINES_ Syntax]

[12.4.5.18. **SHOW ERRORS** Syntax][12.4.5.18. _SHOW ERRORS_ Syntax]

[12.4.5.19. **SHOW EVENTS** Syntax][12.4.5.19. _SHOW EVENTS_ Syntax]

[12.4.5.20. **SHOW FUNCTION CODE** Syntax][12.4.5.20. _SHOW FUNCTION CODE_ Syntax]

[12.4.5.21. **SHOW FUNCTION STATUS** Syntax][12.4.5.21. _SHOW FUNCTION STATUS_ Syntax]

[12.4.5.22. **SHOW GRANTS** Syntax][12.4.5.22. _SHOW GRANTS_ Syntax]

[12.4.5.23. **SHOW INDEX** Syntax][12.4.5.23. _SHOW INDEX_ Syntax]

[12.4.5.24. **SHOW MASTER STATUS** Syntax][12.4.5.24. _SHOW MASTER STATUS_ Syntax]

[12.4.5.25. **SHOW OPEN TABLES** Syntax][12.4.5.25. _SHOW OPEN TABLES_ Syntax]

[12.4.5.26. **SHOW PLUGINS** Syntax][12.4.5.26. _SHOW PLUGINS_ Syntax]

[12.4.5.27. **SHOW PRIVILEGES** Syntax][12.4.5.27. _SHOW PRIVILEGES_ Syntax]

[12.4.5.28. **SHOW PROCEDURE CODE** Syntax][12.4.5.28. _SHOW PROCEDURE CODE_ Syntax]

[12.4.5.29. **SHOW PROCEDURE STATUS** Syntax][12.4.5.29. _SHOW PROCEDURE STATUS_ Syntax]

[12.4.5.30. **SHOW PROCESSLIST** Syntax][12.4.5.30. _SHOW PROCESSLIST_ Syntax]

[12.4.5.31. **SHOW PROFILE** Syntax][12.4.5.31. _SHOW PROFILE_ Syntax]

[12.4.5.32. **SHOW PROFILES** Syntax][12.4.5.32. _SHOW PROFILES_ Syntax]

[12.4.5.33. **SHOW RELAYLOG EVENTS** Syntax][12.4.5.33. _SHOW RELAYLOG EVENTS_ Syntax]

[12.4.5.34. **SHOW SLAVE HOSTS** Syntax][12.4.5.34. _SHOW SLAVE HOSTS_ Syntax]

[12.4.5.35. **SHOW SLAVE STATUS** Syntax][12.4.5.35. _SHOW SLAVE STATUS_ Syntax]

[12.4.5.36. **SHOW STATUS** Syntax][12.4.5.36. _SHOW STATUS_ Syntax]

[12.4.5.37. **SHOW TABLE STATUS** Syntax][12.4.5.37. _SHOW TABLE STATUS_ Syntax]

[12.4.5.38. **SHOW TABLES** Syntax][12.4.5.38. _SHOW TABLES_ Syntax]

[12.4.5.39. **SHOW TRIGGERS** Syntax][12.4.5.39. _SHOW TRIGGERS_ Syntax]

[12.4.5.40. **SHOW VARIABLES** Syntax][12.4.5.40. _SHOW VARIABLES_ Syntax]

[12.4.5.41. **SHOW WARNINGS** Syntax][12.4.5.41. _SHOW WARNINGS_ Syntax]

[**SHOW**][http_dev.mysql.com_doc_refman_5.5_en_show.html] 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*

[http_dev.mysql.com_doc_refman_5.5_en_show.html]: http://dev.mysql.com/doc/refman/5.5/en/show.html
[12.4.5.1. _SHOW AUTHORS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-authors.html
[12.4.5.2. _SHOW BINARY LOGS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-binary-logs.html
[12.4.5.3. _SHOW BINLOG EVENTS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-binlog-events.html
[12.4.5.4. _SHOW CHARACTER SET_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-character-set.html
[12.4.5.5. _SHOW COLLATION_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-collation.html
[12.4.5.6. _SHOW COLUMNS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-columns.html
[12.4.5.7. _SHOW CONTRIBUTORS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-contributors.html
[12.4.5.8. _SHOW CREATE DATABASE_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-create-database.html
[12.4.5.9. _SHOW CREATE EVENT_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-create-event.html
[12.4.5.10. _SHOW CREATE FUNCTION_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-create-function.html
[12.4.5.11. _SHOW CREATE PROCEDURE_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-create-procedure.html
[12.4.5.12. _SHOW CREATE TABLE_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-create-table.html
[12.4.5.13. _SHOW CREATE TRIGGER_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-create-trigger.html
[12.4.5.14. _SHOW CREATE VIEW_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-create-view.html
[12.4.5.15. _SHOW DATABASES_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-databases.html
[12.4.5.16. _SHOW ENGINE_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-engine.html
[12.4.5.17. _SHOW ENGINES_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-engines.html
[12.4.5.18. _SHOW ERRORS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-errors.html
[12.4.5.19. _SHOW EVENTS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-events.html
[12.4.5.20. _SHOW FUNCTION CODE_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-function-code.html
[12.4.5.21. _SHOW FUNCTION STATUS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-function-status.html
[12.4.5.22. _SHOW GRANTS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-grants.html
[12.4.5.23. _SHOW INDEX_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-index.html
[12.4.5.24. _SHOW MASTER STATUS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-master-status.html
[12.4.5.25. _SHOW OPEN TABLES_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-open-tables.html
[12.4.5.26. _SHOW PLUGINS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-plugins.html
[12.4.5.27. _SHOW PRIVILEGES_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-privileges.html
[12.4.5.28. _SHOW PROCEDURE CODE_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-procedure-code.html
[12.4.5.29. _SHOW PROCEDURE STATUS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-procedure-status.html
[12.4.5.30. _SHOW PROCESSLIST_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-processlist.html
[12.4.5.31. _SHOW PROFILE_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-profile.html
[12.4.5.32. _SHOW PROFILES_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-profiles.html
[12.4.5.33. _SHOW RELAYLOG EVENTS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-relaylog-events.html
[12.4.5.34. _SHOW SLAVE HOSTS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-slave-hosts.html
[12.4.5.35. _SHOW SLAVE STATUS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-slave-status.html
[12.4.5.36. _SHOW STATUS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-status.html
[12.4.5.37. _SHOW TABLE STATUS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-table-status.html
[12.4.5.38. _SHOW TABLES_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-tables.html
[12.4.5.39. _SHOW TRIGGERS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-triggers.html
[12.4.5.40. _SHOW VARIABLES_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-variables.html
[12.4.5.41. _SHOW WARNINGS_ Syntax]: http://dev.mysql.com/doc/refman/5.5/en/show-warnings.html