mysql实现经纬度计算两个坐标之间的距离sql语句

select *,(2 * 6378.137* ASIN(SQRT(POW(SIN(PI()*(111.86141967773438-latitude)/360),2)+COS(PI()*33.07078170776367/180)* COS(latitude * PI()/180)*POW(SIN(PI()*(33.07078170776367-longitude)/360),2)))) as juli from school_base_info
order by juli asc limit 0,20

mysql实现经纬度计算两个坐标之间的距离sql语句

标签：pow   sql语句   info   cos   base   select   div   ase   mysq