如何在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)'));

DELIMITER //
CREATE PROCEDURE add_location(IN p_name VARCHAR(255), IN p_point GEOMETRY)
BEGIN
  INSERT INTO locations (name, point)
  VALUES (p_name, p_point);
END //
DELIMITER ;

CALL add_location('Los Angeles', ST_GeomFromText('POINT(-118.2437 34.0522)'));