mysql经纬度存储格式geometry

-- 创建表
CREATE TABLE locations (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    coordinates GEOMETRY(Point, 4326)
);

-- 插入数据
INSERT INTO locations (name, coordinates) VALUES
('Location A', ST_GeomFromText('POINT(120.123 30.456)')),
('Location B', ST_GeomFromText('POINT(121.789 31.123)'));

-- 查询数据
SELECT name, ST_AsText(coordinates) AS coordinates FROM locations;

-- 计算距离
SELECT ST_Distance_Sphere(coordinates, ST_GeomFromText('POINT(120.123 30.456)')) AS distance
FROM locations;

INSERT INTO locations (name, coordinates) VALUES
('Location A', ST_GeomFromText('POINT(120.123 30.456)', 4326));

SELECT ST_Distance_Sphere(coordinates, ST_GeomFromText('POINT(120.123 30.456)')) AS distance
FROM locations;

SELECT name
FROM locations
WHERE ST_DWithin(coordinates, ST_GeomFromText('POINT(120.123 30.456)'), 10000);