MySQL Forums
Forum List  »  Federated Storage Engine

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
10237
May 24, 2010 01:05AM
5199
August 16, 2010 02:17AM
4251
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.