SELECT LONGITUDE,LATITUDE,
round(6378.138*2*asin(sqrt(pow(sin((你的纬度*pi()/180-LATITUDE*pi()/180)/2),2)+cos(你的纬度*pi()/180)*cos(LATITUDE*pi()/180)*
pow(sin((你的经度*pi()/180-LONGITUDE*pi()/180)/2),2)))*1000)
FROM xxx
round(6378.138*2*asin(sqrt(pow(sin((你的纬度*pi()/180-LATITUDE*pi()/180)/2),2)+cos(你的纬度*pi()/180)*cos(LATITUDE*pi()/180)*
pow(sin((你的经度*pi()/180-LONGITUDE*pi()/180)/2),2)))*1000)
FROM xxx