MySQL Forums
Forum List  »  Federated Storage Engine

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
10237
May 24, 2010 01:05AM
5199
August 16, 2010 02:17AM
Re: Creating Federated Tables
4250
November 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.