Solved

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

Posted on 2008-09-30
3
1,386 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 142

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 142

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

867 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now