请教一个问题在分区中建立中文全文索引,建表会出错,如果只有分区或者只有中文全文索引就不出错
DROP TABLE IF EXISTS `data_contents`;
CREATE TABLE `data_contents` (
`Pid` int(11) NOT NULL COMMENT '文章总号',
`Title` char(250) NOT NULL COMMENT '标题',
`Contents` text NOT NULL COMMENT '内文',
`Other` char(250) NOT NULL COMMENT '其他',
`images` char(250) NOT NULL COMMENT '图URL地址',
KEY `Pid` (`Pid`),
FULLTEXT KEY `Title_Contents` (`Title`,`Contents`) WITH PARSER `scws_parser`
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文章內文表' /*!50100 PARTITION BY LINEAR KEY (Pid) PARTITIONS 10 */;出错:
MySQL 返回: #1214 - The used table type doesn't support FULLTEXT indexes
DROP TABLE IF EXISTS `data_contents`;
CREATE TABLE `data_contents` (
`Pid` int(11) NOT NULL COMMENT '文章总号',
`Title` char(250) NOT NULL COMMENT '标题',
`Contents` text NOT NULL COMMENT '内文',
`Other` char(250) NOT NULL COMMENT '其他',
`images` char(250) NOT NULL COMMENT '图URL地址',
KEY `Pid` (`Pid`),
FULLTEXT KEY `Title_Contents` (`Title`,`Contents`) WITH PARSER `scws_parser`
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文章內文表' /*!50100 PARTITION BY LINEAR KEY (Pid) PARTITIONS 10 */;出错:
MySQL 返回: #1214 - The used table type doesn't support FULLTEXT indexes
mysql中分区是否能支持全文索引呢?
Partitioned tables do not support FULLTEXT indexes, including tables that use the MYISAM storage engine.
hey,这里面已经明确说不支持全文索引了
建议楼主尝试一下sphinx