Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 12.5.5 SHOW Syntax
- 12.5.5.1 SHOW BINARY LOGS Syntax
- 12.5.5.2 SHOW BINLOG EVENTS Syntax
- 12.5.5.3 SHOW CHARACTER SET Syntax
- 12.5.5.4 SHOW COLLATION Syntax
- 12.5.5.5 SHOW COLUMNS Syntax
- 12.5.5.6 SHOW CREATE DATABASE Syntax
- 12.5.5.7 SHOW CREATE FUNCTION Syntax
- 12.5.5.8 SHOW CREATE PROCEDURE Syntax
- 12.5.5.9 SHOW CREATE TABLE Syntax
- 12.5.5.10 SHOW CREATE VIEW Syntax
- 12.5.5.11 SHOW DATABASES Syntax
- 12.5.5.12 SHOW ENGINE Syntax
- 12.5.5.13 SHOW ENGINES Syntax
- 12.5.5.14 SHOW ERRORS Syntax
- 12.5.5.15 SHOW FUNCTION CODE Syntax
- 12.5.5.16 SHOW FUNCTION STATUS Syntax
- 12.5.5.17 SHOW GRANTS Syntax
- 12.5.5.18 SHOW INDEX Syntax
- 12.5.5.19 SHOW INNODB STATUS Syntax
- 12.5.5.20 SHOW LOGS Syntax
- 12.5.5.21 SHOW MASTER STATUS Syntax
- 12.5.5.22 SHOW MUTEX STATUS Syntax
- 12.5.5.23 SHOW OPEN TABLES Syntax
- 12.5.5.24 SHOW PRIVILEGES Syntax
- 12.5.5.25 SHOW PROCEDURE CODE Syntax
- 12.5.5.26 SHOW PROCEDURE STATUS Syntax
- 12.5.5.27 SHOW PROCESSLIST Syntax
- 12.5.5.28 SHOW PROFILE Syntax
- 12.5.5.29 SHOW PROFILES Syntax
- 12.5.5.30 SHOW SLAVE HOSTS Syntax
- 12.5.5.31 SHOW SLAVE STATUS Syntax
- 12.5.5.32 SHOW STATUS Syntax
- 12.5.5.33 SHOW TABLE STATUS Syntax
- 12.5.5.34 SHOW TABLES Syntax
- 12.5.5.35 SHOW TRIGGERS Syntax
- 12.5.5.36 SHOW VARIABLES Syntax
- 12.5.5.37 SHOW WARNINGS Syntax
SHOW {DATABASES | SCHEMAS}
[LIKE 'pattern' | WHERE expr]
SHOW DATABASES lists the
databases on the MySQL server host.
SHOW
SCHEMAS is a synonym for SHOW
DATABASES as of MySQL 5.0.2. The
LIKE clause, if present, indicates
which database names to match. The WHERE
clause can be given to select rows using more general
conditions, as discussed in Section 19.19, “Extensions to SHOW Statements”.
You see only those databases for which you have some kind of
privilege, unless you have the global SHOW
DATABASES privilege. You can also get this list using
the mysqlshow command.
If the server was started with the
--skip-show-database option, you cannot use
this statement at all unless you have the
SHOW DATABASES privilege.
User Comments
Add your own comment.