DROP SERVER [ IF EXISTS ] server_name
Drops the server definition for the server named 删除名为
. server_name
server_name
的服务器的服务器定义。The corresponding row in the 将删除mysql.servers
table is deleted. mysql.servers
表中的对应行。This statement requires the 此语句需要SUPER
privilege.SUPER
权限。
Dropping a server for a table does not affect any 删除表的服务器不会影响创建时使用此连接信息的任何FEDERATED
tables that used this connection information when they were created. FEDERATED
(联合)表。See Section 13.1.18, “CREATE SERVER Statement”.请参阅第13.1.18节,“CREATE SERVER语句”。
DROP SERVER
causes an implicit commit. DROP SERVER
导致隐式提交。See Section 13.3.3, “Statements That Cause an Implicit Commit”.请参阅第13.3.3节,“导致隐式提交的语句”。
无论使用何种日志格式,DROP SERVER
is not written to the binary log, regardless of the logging format that is in use.DROP SERVER
都不会写入二进制日志。