SHOW |
Afficher |
|---|---|
| MySQL |
Syntaxe
| SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern'] |
| SHOW CREATE DATABASE db_name |
| SHOW CREATE TABLE tbl_name |
| SHOW DATABASES [LIKE 'pattern'] |
| SHOW [STORAGE] ENGINES |
| SHOW ERRORS [LIMIT [offset,] row_count] |
| SHOW GRANTS FOR user |
| SHOW INDEX FROM tbl_name [FROM db_name] |
| SHOW INNODB STATUS |
| SHOW [BDB] LOGS |
| SHOW PRIVILEGES |
| SHOW [FULL] PROCESSLIST |
| SHOW STATUS [LIKE 'LIKE'] |
| SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern'] |
| SHOW [OPEN] TABLES [FROM db_name] [LIKE 'pattern'] |
| SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern'] |
| SHOW WARNINGS [LIMIT [offset,] row_count] |
Description
Cette instruction permet d'afficher des informations sur une structure de données quelconque.
Voir également
Article - Les géants de l'informatique - Oracle
Références
MySQL - Référence, Edition Micro Application, Nicolas Rivereau, Antoine Pichot, 2002, ISBN: 2-7429-2560-0, page 912.
MySQL: The definitive guide to using, programming, and administering MySQL 4 databases - Second Edition, Paul Dubois, 2003, ISBN: 0-7357-1212-3, page 898
Dernière mise à jour : Lundi, le 14 septembre 2015