MySQL Forums :: Federated Storage Engine :: Creating Federated Tables
Re: Creating Federated Tables
Posted by: iso81 iso81 ()
Date: November 03, 2010 08:11AM
CREATE TABLE sys_client (
# list all your attributes here
)
ENGINE = FEDERATED
DEFAULT CHARSET = utf8
COMMENT = 'write your comment here'
CONNECTION = 'mysql://user:user1@192.168.40.22:3306/testDB/sys_client';
Federated engine must be enabled, review your my.cnf file.
# list all your attributes here
)
ENGINE = FEDERATED
DEFAULT CHARSET = utf8
COMMENT = 'write your comment here'
CONNECTION = 'mysql://user:user1@192.168.40.22:3306/testDB/sys_client';
Federated engine must be enabled, review your my.cnf file.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Creating Federated Tables | 5257 | Megha Razdan | 05/24/2010 01:05AM |
| Re: Creating Federated Tables | 2635 | Arnab Saha | 08/16/2010 02:17AM |
| Re: Creating Federated Tables | 1841 | iso81 iso81 | 11/03/2010 08:11AM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates