(mysql.info) schemata-table
Info Catalog
(mysql.info) information-schema
(mysql.info) information-schema
(mysql.info) tables-table
20.1 The `INFORMATION_SCHEMA SCHEMATA' Table
============================================
A schema is a database, so the `SCHEMATA' table provides information
about databases.
*`INFORMATION_SCHEMA' Name* *`SHOW' Name* *Remarks*
`CATALOG_NAME' `NULL'
`SCHEMA_NAME' Database
`DEFAULT_CHARACTER_SET_NAME'
`DEFAULT_COLLATION_NAME'
`SQL_PATH' `NULL'
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']
Info Catalog
(mysql.info) information-schema
(mysql.info) information-schema
(mysql.info) tables-table
automatically generated byinfo2html