The world's most popular open source database
Contact a MySQL Representative
Login | Register
INFORMATION_SCHEMA SCHEMATA
A schema is a database, so the SCHEMATA table provides information about databases.
SCHEMATA
INFORMATION_SCHEMA
SHOW
CATALOG_NAME
NULL
SCHEMA_NAME
DEFAULT_CHARACTER_SET_NAME
DEFAULT_COLLATION_NAME
SQL_PATH
Notes:
DEFAULT_COLLATION_NAME was added in MySQL 5.0.6.
The following statements are equivalent:
SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE ' wild'] SHOW DATABASES [LIKE ' wild']
wild
Add your own comment.
User Comments
Add your own comment.