SCHEMATA

SCHEMATA 表提供了关于数据库的信息。表中的数据与 SHOW DATABASES 语句的执行结果等价。

1. USE information_schema;
2. desc SCHEMATA;

1. +----------------------------+--------------+------+------+---------+-------+
2. | Field                      | Type         | Null | Key  | Default | Extra |
3. +----------------------------+--------------+------+------+---------+-------+
4. | CATALOG_NAME               | varchar(512) | YES  |      | NULL    |       |
5. | SCHEMA_NAME                | varchar(64)  | YES  |      | NULL    |       |
6. | DEFAULT_CHARACTER_SET_NAME | varchar(64)  | YES  |      | NULL    |       |
7. | DEFAULT_COLLATION_NAME     | varchar(32)  | YES  |      | NULL    |       |
8. | SQL_PATH                   | varchar(512) | YES  |      | NULL    |       |
9. +----------------------------+--------------+------+------+---------+-------+
10. 5 rows in set (0.00 sec)

1. SELECT * FROM SCHEMATA;

1. +--------------+--------------------+----------------------------+------------------------+----------+
2. | CATALOG_NAME | SCHEMA_NAME        | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
3. +--------------+--------------------+----------------------------+------------------------+----------+
4. | def          | INFORMATION_SCHEMA | utf8mb4                    | utf8mb4_bin            | NULL     |
5. | def          | METRICS_SCHEMA     | utf8mb4                    | utf8mb4_bin            | NULL     |
6. | def          | mysql              | utf8mb4                    | utf8mb4_bin            | NULL     |
7. | def          | PERFORMANCE_SCHEMA | utf8mb4                    | utf8mb4_bin            | NULL     |
8. | def          | test               | utf8mb4                    | utf8mb4_bin            | NULL     |
9. +--------------+--------------------+----------------------------+------------------------+----------+
10. 5 rows in set (0.00 sec)

SCHEMATA 表各列字段含义如下：

• CATALOG_NAME：数据库归属的目录名，该列值永远为 def。
• SCHEMA_NAME：数据库的名字。
• DEFAULT_CHARACTER_SET_NAME：数据库的默认字符集。
• DEFAULT_COLLATION_NAME：数据库的默认 collation。
• SQL_PATH：该项值永远为 NULL。