mysql经纬度

一、sql

-- 39是latitude（纬度）
--  116是longitude（经度）
SELECT 
    6371000 * 2 * ASIN(
        SQRT(
            POW(SIN(RADIANS((latitude - 39.9071109355894) / 2)), 2) +
            COS(RADIANS(39.9071109355894)) * COS(RADIANS(latitude)) * 
            POW(SIN(RADIANS((116.35774612426759 - longitude) / 2)), 2)
        )
    ) AS distance_in_meters
		from coordinates

二、验证距离

https://tool.box3.cn/lbs.html