Solved

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

Posted on 2008-09-30
3
1,410 Views
Last Modified: 2013-11-05
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
0
Comment
Question by:dashish
  • 2
3 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22603754
http://bugs.mysql.com/bug.php?id=24006

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

Author Comment

by:dashish
ID: 22603826
What is the probable solution for it.
Thanks,
dAshish
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 22603873
move the table to MyISAM:

CREATE TABLE geom (g GEOMETRY NOT NULL) ENGINE=MyISAM;

Open in new window

0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question