mysql 距离排序

CREATE TABLE locations (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    latitude DECIMAL(9, 6),
    longitude DECIMAL(9, 6)
);

SELECT 
    id, 
    name, 
    latitude, 
    longitude,
    SQRT(POW(latitude - 37.7749, 2) + POW(longitude - -122.4194, 2)) AS distance
FROM 
    locations
ORDER BY 
    distance;

SELECT 
    id, 
    name, 
    latitude, 
    longitude,
    (
        6371 * acos(cos(radians(37.7749)) * cos(radians(latitude)) * cos(radians(longitude) - radians(-122.4194)) + sin(radians(37.7749)) * sin(radians(latitude)))
    ) AS distance
FROM 
    locations
ORDER BY 
    distance;