文档首页
MySQL 8.4 参考手册
8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

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

打开官方英文原文 ↗

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

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

15.1.30 DROP SERVER 语句15.1.30 DROP SERVER Statement

DROP SERVER [ IF EXISTS ] server_name

删除名为server_name的服务器定义。对应的行在mysql.servers表已被删除。此语句需要SUPER特权。Drops the server definition for the server named server_name. The corresponding row in the mysql.servers table is deleted. This statement requires the SUPER privilege.

丢弃服务器不会影响创建时使用该连接信息的任何 FEDERATED 表。参见 第 15.1.18 节,“CREATE SERVER 语句”。Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. See Section 15.1.18, “CREATE SERVER Statement”.

DROP SERVER 会导致隐式提交。参见 第 15.3.3 节,“导致隐式提交的语句”。DROP SERVER causes an implicit commit. See Section 15.3.3, “Statements That Cause an Implicit Commit”.

DROP SERVER 不会写入二进制日志,无论使用何种日志格式。DROP SERVER is not written to the binary log, regardless of the logging format that is in use.