【小(xiǎo)編推薦】mysql中2個(gè)坐(zuò)标距離(lí)$•∑計(jì)算(suàn)

2015-05-01   |&nπ¶©bsp;  發布者:梁β↕國(guó)芳   |&×✘↓Ωnbsp;  查看(kàn):3320次

app開(kāi)發
select id,lng,lat, ROUND(6378.138*2*A♦©SIN(SQRT(POW(SIN((39.963396*P>♠I()/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