【小编推荐】mysql中2个坐标距离计算

2015-05-01   |   发布者:梁国芳   |   查看:3320次

app开发
select id,lng,lat, ROUND(6378.138*2*ASIN(SQRT(POW(SIN((39.963396*PI()/180-lat*PI()/180)/2),2)+COS(39.963396*PI()/180)*COS(lat*PI()/180)*POW(SIN((116.470384*PI()/180-lng*PI()/180)/2),2)))*1000) AS juli FROM store_info ORDER BY juli DESC LIMIT 316