Solved

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

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL - Limit or Top Records 15 49
mysql sql statement - SQL INSERT INTO SELECT 11 65
Insert data into database 2 42
change database name 2 29
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikipedia.org/wiki/PHP  Very powerful.  But a…
Creating and Managing Databases with phpMyAdmin in cPanel.
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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