mysql数据库有schema吗_mysql数据库schema是什么

慕村9548890

123456789101112131415161718MySQL 中 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)