MySQL 中 Schema 等价于 数据库。
mysql> SELECT
-> SCHEMA_NAME,
-> DEFAULT_CHARACTER_SET_NAME,
-> DEFAULT_COLLATION_NAME
-> FROM
-> INFORMATION_SCHEMA.SCHEMATA;
+--------------------+----------------------------+------------------------+
| SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+--------------------+----------------------------+------------------------+
| information_schema | utf8 | utf8_general_ci |
| mysql | latin1 | latin1_swedish_ci |
| sqldoc | utf8 | utf8_general_ci |
| test | latin1 | latin1_swedish_ci |
| test2 | latin1 | latin1_swedish_ci |
+--------------------+----------------------------+------------------------+
5 rows in set (0.00 sec)