- 12.5.5 SHOW Syntax
- 12.5.5.1 SHOW AUTHORS Syntax
- 12.5.5.2 SHOW BINARY LOGS Syntax
- 12.5.5.3 SHOW BINLOG EVENTS Syntax
- 12.5.5.4 SHOW CHARACTER SET Syntax
- 12.5.5.5 SHOW COLLATION Syntax
- 12.5.5.6 SHOW COLUMNS Syntax
- 12.5.5.7 SHOW CONTRIBUTORS Syntax
- 12.5.5.8 SHOW CREATE DATABASE Syntax
- 12.5.5.9 SHOW CREATE EVENT Syntax
- 12.5.5.10 SHOW CREATE FUNCTION Syntax
- 12.5.5.11 SHOW CREATE PROCEDURE Syntax
- 12.5.5.12 SHOW CREATE TABLE Syntax
- 12.5.5.13 SHOW CREATE TRIGGER Syntax
- 12.5.5.14 SHOW CREATE VIEW Syntax
- 12.5.5.15 SHOW DATABASES Syntax
- 12.5.5.16 SHOW ENGINE Syntax
- 12.5.5.17 SHOW ENGINES Syntax
- 12.5.5.18 SHOW ERRORS Syntax
- 12.5.5.19 SHOW EVENTS Syntax
- 12.5.5.20 SHOW FUNCTION CODE Syntax
- 12.5.5.21 SHOW FUNCTION STATUS Syntax
- 12.5.5.22 SHOW GRANTS Syntax
- 12.5.5.23 SHOW INDEX Syntax
- 12.5.5.24 SHOW INNODB STATUS Syntax
- 12.5.5.25 SHOW MASTER STATUS Syntax
- 12.5.5.26 SHOW OPEN TABLES Syntax
- 12.5.5.27 SHOW PLUGINS Syntax
- 12.5.5.28 SHOW PRIVILEGES Syntax
- 12.5.5.29 SHOW PROCEDURE CODE Syntax
- 12.5.5.30 SHOW PROCEDURE STATUS Syntax
- 12.5.5.31 SHOW PROCESSLIST Syntax
- 12.5.5.32 SHOW PROFILE Syntax
- 12.5.5.33 SHOW PROFILES Syntax
- 12.5.5.34 SHOW SCHEDULER STATUS Syntax
- 12.5.5.35 SHOW SLAVE HOSTS Syntax
- 12.5.5.36 SHOW SLAVE STATUS Syntax
- 12.5.5.37 SHOW STATUS Syntax
- 12.5.5.38 SHOW TABLE STATUS Syntax
- 12.5.5.39 SHOW TABLES Syntax
- 12.5.5.40 SHOW TRIGGERS Syntax
- 12.5.5.41 SHOW VARIABLES Syntax
- 12.5.5.42 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. 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.28, “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.
MySQL implements databases as directories in the data directory, so this statement simply lists directories in that location. However, the output may include names of directories that do not correspond to actual databases.
User Comments
Hopefully useful to have documented here - if you need to dynamically determine the active database, SELECT DATABASE(); will return one row containing the current database name for the active connection.
Add your own comment.