<div>
<a href="http://bugs.mysql.com/bug.php?id=24006" rel="ugc">http://bugs.mysql.com/bug.php?id=24006</a><br />
<br />
your table is probably on InnoDB, which does not support spatial index.
</div>


http://bugs.mysql.com/bug.php?id=24006 [http://bugs.mysql.com/bug.php?id=24006]

your table is probably on InnoDB, which does not support spatial index.

<div>
What is the probable solution for it.<br />
Thanks,<br />
dAshish
</div>


What is the probable solution for it.
Thanks,
dAshish

<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
I am working on MySQL server 5.0.<br />
I have created a table using command<br />
&nbsp;CREATE TABLE geom (g GEOMETRY NOT NULL); <br />
<br />
Now I want to create spatial index on column 'g' using command.<br />
&nbsp;CREATE SPATIAL INDEX sp_index ON geom (g);<br />
<br />
It gives me following error - <br />
&quot;ERROR 1464 (HY000): The used table type doesn't support SPATIAL indexes&quot;<br />
<br />
Please give me some information about this problem.<br />
<br />
Thanks in advance,<br />
Regards,<br />
dAshish
</div>
</div>


Hello All,

I am working on MySQL server 5.0.
I have created a table using command
 CREATE TABLE geom (g GEOMETRY NOT NULL); 

Now I want to create spatial index on column 'g' using command.
 CREATE SPATIAL INDEX sp_index ON geom (g);

It gives me following error - 
"ERROR 1464 (HY000): The used table type doesn't support SPATIAL indexes"

Please give me some information about this problem.

Thanks in advance,
Regards,
dAshish

Problem giving while creating spatial index on geomentry column in MySql server.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.