How to Create FEDERATED Tables-opracowanie

How to Create FEDERATED Tables
To create a FEDERATED table you should follow these steps:
1. Create the table on the remote server. Alternatively, make a note of the table definition of an
existing table, perhaps using the SHOW CREATE TABLE statement.
2. Create the table on the local server with an identical table definition, but adding the connection
information that links the local table to the remote table.
For example, you could create the following table on the remote server:
CREATE TABLE test_table (
id INT(20) NOT NULL AUTO_INCREMENT,
... zobacz całą notatkę