[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2008-09-30
3
Medium Priority
?
1,482 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

656 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