如何在GEO数据库中创建和使用地理空间索引？

CREATE TABLE locations (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  point GEOMETRY NOT NULL
);

INSERT INTO locations (name, point)
VALUES ('New York', ST_GeomFromText('POINT(-74.0060 40.7128)'));

ALTER TABLE locations ADD SPATIAL INDEX(point);

SELECT name, ST_AsText(point)
FROM locations
WHERE ST_Distance_Sphere(point, ST_GeomFromText('POINT(-74.0060 40.7128)')) <= 100000;