Used table type does not support SPATIAL indexes

Question

"The table type used does not support SPATIAL indexes"

I have this error in MySQL when I run a query that includes the keyword “contains”. How to make the table support "SPATIAL indexes". Request

select * from the table where it is contained (column, "1")

Answer 1

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

Answer 2

Mysql support for spatial indexes first added for tables with the MyISAM engine. Support for the InnoDB engine from version 5.7.5.

MyISAM: >= 5.0 InnoDB: >= 5.7.5