select s.*,ROUND(6378.138*2*ASIN(SQRT(POW(SIN(("+latitude+"*PI()/180-s.`latitude`*PI()/180)/2),2)+COS(s.`latitude`*PI()/180)*COS(s.`latitude`*PI()/180)*POW(SIN((+"+longitude+"*PI()/180-s.`longitude`*PI()/180)/2),2)))*1000) AS dis
mysql根据经纬度计算距离sql语句
最新推荐文章于 2024-08-06 18:14:18 发布