ALTER SERVER Syntax

Alters the server information for server_name, adjusting any of the options allowed in the CREATE SERVER statement. See , "CREATE SERVER Syntax". The corresponding fields in the mysql.servers table are updated accordingly. This statement requires the SUPER privilege.

For example, to update the USER option:

ALTER SERVER s OPTIONS (USER 'sally');

ALTER SERVER does not cause an automatic commit.

Retornar