FEDERATED table allows you to work with remote tables and not to store them locally.
To create a FEDERATED table, use the database where the table is stored.
Select the FEDERATED storage engine type in the Engine combo box.
You can edit a federated table by selecting Edit Table on the Database Explorer node shortcut menu. All the changes you make will be also shown on the server where the table is stored.
You can drop the federated table by selecting Delete on the Database Explorer node shortcut menu. Once the connection is broken between the running servers, you can make changes and view the result changes only on the server that stores the tables.
If you have MySQL 5.0.13 installed, use COMMENT rather than CONNECTION.