(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