关于MySQL的全文索引问题
CREATE TABLE `dbo_u2m_activities` (`id` bigint(20) NOT NULL auto_increment,
`ActivitiesName` varchar(50) default NULL COMMENT '活动名称',
`AdminID` bigint(20) default '0' COMMENT '发起人',
`ActivitiesClass` int(11) default '0' COMMENT '类别',
`ActivitiesPayClass` int(11) default '0' COMMENT '支付类型0不需要1需要',
`ActivitiesContent` longtext COMMENT '活动内容',
`ActivitiesSitus` smallint(1) default NULL COMMENT '1圈内0开放2好友',
`ActivitiesPayMoney` int(11) default '0' COMMENT '费用',
`ActivitiesStartime` bigint(20) default '0' COMMENT '开始时间',
`ActivitiesEndtime` bigint(20) default '0' COMMENT '结束时间',
`ActivitiesStime` bigint(20) default '0' COMMENT '报名截止时间',
`ActivitiesUpTime` bigint(20) default '0' COMMENT '发布时间',
`ActivitiesMan` smallint(6) NOT NULL default '0' COMMENT '人数限制,0的时候为不限制',
`ALTX` varchar(50) default NULL,
`ALTY` varchar(50) default NULL,
PRIMARY KEY (`id`),
KEY `AdminID` (`AdminID`),
FULLTEXT KEY `ActivitiesName` (`ActivitiesName`),
FULLTEXT KEY `ActivitiesContent` (`ActivitiesContent`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
创建了FULLTEXT为何我SELECT * FROM dbo_u2m_activities WHERE MATCH (ActivitiesName,ActivitiesContent) AGAINST ('1978');
的时候却提示Error Code : 1191
Can't find FULLTEXT index matching the column list
#-----无法找到与列列表匹配的FULLTEXT索引
难道真的是:它们不使用 50% 域值。. 在后面加了IN BOOLEAN MODE结果是0行
页:
[1]