Skip navigation links

MySQL Forums :: Federated Storage Engine :: Creating Federated Tables


Advanced Search

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
Creating Federated Tables 6744 Megha Razdan 05/24/2010 01:05AM
Re: Creating Federated Tables 3290 Arnab Saha 08/16/2010 02:17AM
Re: Creating Federated Tables 2429 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.