ROUND(6378.138*2*ASIN(SQRT(POW(SIN((#{lat}*PI()/180-bd_latitude*PI()/180)/2),2)+COS(#{lat}*PI()/180)*COS(bd_latitude*PI()/180)*POW(SIN((#{lng}*PI()/180-bd_longitude*PI()/180)/2),2)))*1000) AS distance
mysql 按照经纬度计算距离
最新推荐文章于 2024-08-06 18:14:18 发布