mysql fulltext类型,mysql – 使用的表类型不支持FULLTEXT索引

我将此表数据导入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

在localhost我添加标题和long_desc的全文,所以这工作,但当我导入我看到这个错误.如何修复此错误？

解决方法:

您需要将引擎更改为MyISAM.完整文本在INNODB中的MySQL 5.6之后支持搜索.你可以在here以上查看.

Full-text searches are supported for MyISAM tables only. (In MySQL 5.6

and up, they can also be used with InnoDB tables.)

标签：mysql

来源： https://codeday.me/bug/20190722/1504070.html