使用的表类型不支持SPATIAL索引

"The used table type doesn't support SPATIAL indexes"

“使用的表类型不支持SPATIAL索引”

I have got this error in MySQL when i am running a query which includes "contains" keyword. How to make a table support "SPATIAL indexes". The query is

当我运行包含“contains”关键字的查询时,我在MySQL中遇到此错误。如何使表支持“SPATIAL索引”。查询是

select * from table where contains(column,"1")

select * from table where contains(column,“1”)

2 个解决方案

#1

Mysql support spatial index only with *.myisam tables, i.e. the ISAM engine. Link: http://dev.mysql.com/doc/refman/5.0/en/creating-spatial-indexes.html

Mysql仅支持带有* .myisam表的空间索引,即ISAM引擎。链接:http://dev.mysql.com/doc/refman/5.0/en/creating-spatial-indexes.html

#2

Mysql support for spatial indexes firstly added for tables with MyISAM engine. Support for InnoDB engine added as of version 5.7.5.

首先为具有MyISAM引擎的表添加了对空间索引的Mysql支持。自版本5.7.5起添加了对InnoDB引擎的支持。

MyISAM: >= 5.0
InnoDB: >= 5.7.5