MySQL :: MySQL 8.4 参考手册 :: 28.3.32 INFORMATION_SCHEMA SCHEMATA

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.3 INFORMATION_SCHEMA 总表 / 28.3.32 INFORMATION_SCHEMA SCHEMATA_EXTENSIONS 表

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 100%

28.3.32 INFORMATION_SCHEMA SCHEMATA_EXTENSIONS 表28.3.32 The INFORMATION_SCHEMA SCHEMATA_EXTENSIONS Table

SCHEMATA_EXTENSIONS 表通过提供关于模式选项的信息来扩展 SCHEMATA 表。The SCHEMATA_EXTENSIONS table augments the SCHEMATA table with information about schema options.

SCHEMATA_EXTENSIONS 表具有以下列：The SCHEMATA_EXTENSIONS table has these columns:

CATALOG_NAMECATALOG_NAME
模式所属目录的名称。此值始终为 def。The name of the catalog to which the schema belongs. This value is always def.
SCHEMA_NAMESCHEMA_NAME
模式的名称。The name of the schema.
OPTIONSOPTIONS
模式的选项。如果模式是只读的，值包含 READ ONLY=1。如果模式不是只读的，则不会出现 READ ONLY 选项。The options for the schema. If the schema is read only, the value contains READ ONLY=1. If the schema is not read only, no READ ONLY option appears.

示例Example

mysql> ALTER SCHEMA mydb READ ONLY = 1;
mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA_EXTENSIONS
       WHERE SCHEMA_NAME = 'mydb';
+--------------+-------------+-------------+
| CATALOG_NAME | SCHEMA_NAME | OPTIONS     |
+--------------+-------------+-------------+
| def          | mydb        | READ ONLY=1 |
+--------------+-------------+-------------+

mysql> ALTER SCHEMA mydb READ ONLY = 0;
mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA_EXTENSIONS
       WHERE SCHEMA_NAME = 'mydb';
+--------------+-------------+---------+
| CATALOG_NAME | SCHEMA_NAME | OPTIONS |
+--------------+-------------+---------+
| def          | mydb        |         |
+--------------+-------------+---------+

注意事项Notes

SCHEMATA_EXTENSIONS 是一个非标准的 INFORMATION_SCHEMA 表。SCHEMATA_EXTENSIONS is a nonstandard INFORMATION_SCHEMA table.

首页上一级下一节