13.1.30 DROP SERVER Statement语句

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都不会写入二进制日志。