Skip navigation links

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


Advanced Search

Creating Federated Tables
Posted by: Megha Razdan ()
Date: May 24, 2010 01:05AM

Hello All,
Following is the script:

CREATE TABLE `sys_client` (
`CLIENT_ID` bigint(20) NOT NULL DEFAULT '0',
`NAME` varchar(50) NOT NULL,
`DESCRIPTION` varchar(250) DEFAULT NULL,
`ACTIVE_FLAG` char(1) NOT NULL DEFAULT 'Y',
`ISSYS_FLAG` char(1) NOT NULL DEFAULT 'N',
`LICENSE_STARTDATE` datetime NOT NULL,
`LICENSE_ENDDATE` datetime NOT NULL,
`LICENSE_CONCURRENT_SESSION` int(10) unsigned NOT NULL DEFAULT '0',
`LICENSE_RENEWALMETHOD` char(1) NOT NULL DEFAULT 'A',
`CREATED_ON` datetime NOT NULL,
`CREATED_BY_USER_ID` bigint(20) unsigned NOT NULL,
`UPDATED_ON` datetime NOT NULL,
`UPDATED_BY_USER_ID` bigint(20) unsigned NOT NULL,
`ISDELETED` char(1) DEFAULT 'N',
PRIMARY KEY (`CLIENT_ID`),
UNIQUE KEY `UNI_SYS_CLIENT_NAME` (`NAME`),
KEY `INX_SYS_CLIENT_ACTIVE_FLAG` (`ACTIVE_FLAG`),
KEY `INX_SYS_CLIENT_ISSYS_FLAG` (`ISSYS_FLAG`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='It is designed to partition all entities related' engine='FEDERATED'
connection='mysql://user:user1@192.168.40.22:3306/testDB/sys_client';
;
i ran this on my local server.
It gave the following error: "Unknown table engine 'FEDERATED'"

Server version is 5.1.30
Why is this happening?

Options: ReplyQuote


Subject Views Written By Posted
Creating Federated Tables 6295 Megha Razdan 05/24/2010 01:05AM
Re: Creating Federated Tables 3063 Arnab Saha 08/16/2010 02:17AM
Re: Creating Federated Tables 2228 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.