使用的表类型不支持SPATIAL索引 [英] The used table type doesn't support SPATIAL indexes

问题描述

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

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

当我运行包含"contains"关键字的查询时，我在MySQL中收到此错误.如何使表支持空间索引".查询是

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(column，"1")的表中选择*

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

推荐答案

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

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

这篇关于使用的表类型不支持SPATIAL索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！