请问怎么设置在用table支持FULLTEXT indexes

请问怎么设置在用table支持FULLTEXT indexes??

给你个例子如下， key 就是index columns,  把需要检索的栏放在里面

DROP TABLE IF EXISTS `test`.`demo_people`;
CREATE TABLE  `test`.`demo_people` (
  `name` varchar(80) NOT NULL,
  `phone` varchar(45) NOT NULL,
  `pid` varchar(45) NOT NULL,
  PRIMARY KEY (`name`),
  KEY `Index_2` (`phone`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

感谢您的指教。
但本人试过后，还是不能。
请问我那里做错？

错误讯息写着：The used table type doesn't support FULLTEXT indexes.

以下是我用的query：
SELECT pid, name, phone, MATCH (pid, phone) AGAINST ('"abc" "hunting" "testing"' IN BOOLEAN MODE) AS relevancy FROM demo_people WHERE MATCH (pid, phone) AGAINST ('"abc" "hunting" "testing"' IN BOOLEAN MODE) ORDER BY `relevancy` DESC;