Rechercher dans le manuel MySQL

13.7.6 SHOW Syntax

Table des matières

[+/-]

13.7.6.1 SHOW BINARY LOGS Syntax
13.7.6.2 SHOW BINLOG EVENTS Syntax
13.7.6.3 SHOW CHARACTER SET Syntax
13.7.6.4 SHOW COLLATION Syntax
13.7.6.5 SHOW COLUMNS Syntax
13.7.6.6 SHOW CREATE DATABASE Syntax
13.7.6.7 SHOW CREATE EVENT Syntax
13.7.6.8 SHOW CREATE FUNCTION Syntax
13.7.6.9 SHOW CREATE PROCEDURE Syntax
13.7.6.10 SHOW CREATE TABLE Syntax
13.7.6.11 SHOW CREATE TRIGGER Syntax
13.7.6.12 SHOW CREATE USER Syntax
13.7.6.13 SHOW CREATE VIEW Syntax
13.7.6.14 SHOW DATABASES Syntax
13.7.6.15 SHOW ENGINE Syntax
13.7.6.16 SHOW ENGINES Syntax
13.7.6.17 SHOW ERRORS Syntax
13.7.6.18 SHOW EVENTS Syntax
13.7.6.19 SHOW FUNCTION CODE Syntax
13.7.6.20 SHOW FUNCTION STATUS Syntax
13.7.6.21 SHOW GRANTS Syntax
13.7.6.22 SHOW INDEX Syntax
13.7.6.23 SHOW MASTER STATUS Syntax
13.7.6.24 SHOW OPEN TABLES Syntax
13.7.6.25 SHOW PLUGINS Syntax
13.7.6.26 SHOW PRIVILEGES Syntax
13.7.6.27 SHOW PROCEDURE CODE Syntax
13.7.6.28 SHOW PROCEDURE STATUS Syntax
13.7.6.29 SHOW PROCESSLIST Syntax
13.7.6.30 SHOW PROFILE Syntax
13.7.6.31 SHOW PROFILES Syntax
13.7.6.32 SHOW RELAYLOG EVENTS Syntax
13.7.6.33 SHOW SLAVE HOSTS Syntax
13.7.6.34 SHOW SLAVE STATUS Syntax
13.7.6.35 SHOW STATUS Syntax
13.7.6.36 SHOW TABLE STATUS Syntax
13.7.6.37 SHOW TABLES Syntax
13.7.6.38 SHOW TRIGGERS Syntax
13.7.6.39 SHOW VARIABLES Syntax
13.7.6.40 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:

  1. SHOW {BINARY | MASTER} LOGS
  2. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
  3. SHOW CHARACTER SET [like_or_where]
  4. SHOW COLLATION [like_or_where]
  5. SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]
  6. SHOW CREATE DATABASE db_name
  7. SHOW CREATE EVENT event_name
  8. SHOW CREATE FUNCTION func_name
  9. SHOW CREATE PROCEDURE proc_name
  10. SHOW CREATE TABLE tbl_name
  11. SHOW CREATE TRIGGER trigger_name
  12. SHOW CREATE VIEW view_name
  13. SHOW DATABASES [like_or_where]
  14. SHOW ENGINE engine_name {STATUS | MUTEX}
  15. SHOW [STORAGE] ENGINES
  16. SHOW ERRORS [LIMIT [offset,] row_count]
  17. SHOW EVENTS
  18. SHOW FUNCTION CODE func_name
  19. SHOW FUNCTION STATUS [like_or_where]
  20. SHOW GRANTS FOR user
  21. SHOW INDEX FROM tbl_name [FROM db_name]
  22. SHOW MASTER STATUS
  23. SHOW OPEN TABLES [FROM db_name] [like_or_where]
  24. SHOW PLUGINS
  25. SHOW PROCEDURE CODE proc_name
  26. SHOW PROCEDURE STATUS [like_or_where]
  27. SHOW PRIVILEGES
  28. SHOW [FULL] PROCESSLIST
  29. SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]
  30. SHOW PROFILES
  31. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
  32. SHOW SLAVE HOSTS
  33. SHOW SLAVE STATUS [FOR CHANNEL channel]
  34. SHOW [GLOBAL | SESSION] STATUS [like_or_where]
  35. SHOW TABLE STATUS [FROM db_name] [like_or_where]
  36. SHOW [FULL] TABLES [FROM db_name] [like_or_where]
  37. SHOW TRIGGERS [FROM db_name] [like_or_where]
  38. SHOW [GLOBAL | SESSION] VARIABLES [like_or_where]
  39. SHOW WARNINGS [LIMIT [offset,] row_count]
  40.  
  41. like_or_where:
  42.     LIKE 'pattern'
  43.   | WHERE expr

If the syntax for a given SHOW statement includes a LIKE 'pattern' part, 'pattern' is a string that can contain the SQL % and _ wildcard characters. The pattern is useful for restricting statement output to matching values.

Several SHOW statements also accept a WHERE clause that provides more flexibility in specifying which rows to display. See Section 25.41, “Extensions to SHOW Statements”.

Many MySQL APIs (such as PHP) enable you to treat the result returned from a SHOW statement as you would a result set from a SELECT; see Chapter 28, Connectors and APIs, or your API documentation for more information. In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA database, which you cannot easily do with results from SHOW statements. See Chapter 25, INFORMATION_SCHEMA Tables.


Rechercher dans le manuel MySQL

Traduction non disponible

Le manuel MySQL n'est pas encore traduit en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.

Document créé le 26/06/2006, dernière modification le 26/10/2018
Source du document imprimé : https://www.gaudry.be/mysql-rf-show.html

L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.

Références

  1. Consulter le document html Langue du document :en Manuel MySQL : https://dev.mysql.com/

Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.

Table des matières Haut