SELECT s.*,
(6378.137*ACOS(SIN(29.556647/180*PI())*SIN(s.latitude/180*PI())+COS(29.556647/180*PI())*COS(s.latitude/180*PI())*COS((106.553217-s.longitude)/180*PI()))) AS distance
FROM t_shop s
sql 计算两经纬度之间的距离
最新推荐文章于 2024-03-24 21:01:24 发布
SELECT s.*,
(6378.137*ACOS(SIN(29.556647/180*PI())*SIN(s.latitude/180*PI())+COS(29.556647/180*PI())*COS(s.latitude/180*PI())*COS((106.553217-s.longitude)/180*PI()))) AS distance
FROM t_shop s