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,