DROP SERVER [ IF EXISTS ] server_name
删除名为的服务器定义。对应的行在server_namemysql.servers表已被删除。此语句需要SUPER特权。Drops the server definition for the server named
. The
corresponding row in the server_namemysql.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.