mysql - 使用的表类型不支持 FULLTEXT 索引

Question

我将此表数据导入 phpmyadmin:

CREATE TABLE IF NOT EXISTS `cms_books` (
  `id` bigint(20) NOT NULL,
  `title` varchar(255) COLLATE utf8_persian_ci NOT NULL,
  `seo_title` varchar(255) COLLATE utf8_persian_ci NOT NULL,
  `orginal_title` varchar(255) COLLATE utf8_persian_ci NOT NULL,
  `pub_type` tinyint(2) NOT NULL,
  `long_desc` longtext COLLATE utf8_persian_ci NOT NULL,
  `counter` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8;

我看到这个错误:

--

-- Indexes for table cms_books

--

ALTER TABLE cms_books ADD PRIMARY KEY (id), ADD FULLTEXT KEY title (title), ADD FULLTEXT KEY long_desc (long_desc); MySQL said: Documentation

#1214 - The used table type doesn't support FULLTEXT indexes

在本地主机中，我为标题和 long_desc 添加了 fulltext，所以这有效，但是当我导入时，我看到了这个错误。如何修复此错误？

Answer 1

您需要将引擎更改为 MyISAM。 INNODB MySQL 5.6 之后支持全文搜索。你可以查看一下 here .

参见 MYSQL Docs :

Full-text searches are supported for MyISAM tables only. (In MySQL 5.6 and up, they can also be used with InnoDB tables.)