About SHOW
SHOW
hat viele Formulare, die Informationen über
Datenbanken, Tabellen, Spalten oder Statusinformationen über den Server liefern. Dazu gehören:
- SHOW AUTHORS
- 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 PACKAGE package_name
- SHOW CREATE PACKAGE BODY package_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 [FULL] 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 INNODB 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 [GLOBAL | SESSION] STATUS [like_or_where]
- SHOW TABLE STATUS [FROM db_name] [like_or_where]
- SHOW 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
Wenn die Syntax für eine bestimmte SHOW
-Anweisung einen LIKE 'pattern'
-Teil enthält, ist 'pattern'
eine Zeichenkette, die die SQL-Platzhalterzeichen "%
" und "<<fixed>>
_</fixed>>" enthalten kann. Das Muster ist nützlich, um die Anweisungsausgabe auf passende Werte zu beschränken.
Einige SHOW
-Anweisungen akzeptieren auch eine WHERE
-Klausel, die mehr Flexibilität bei der Angabe der anzuzeigenden Zeilen bietet. Siehe Extended Show.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.