lat 纬度
lng 经度
ROUND(6378.138*2*asin(sqrt(pow(sin((lat1*pi()/180-lat2*pi()/180)/2),2)+cos(lat1*pi()/180)*cos(lat2*pi()/180)*pow(sin( (lng1*pi()/180-lng2*pi()/180)/2),2)))*1000)
SELECT m.id,m.name,m.longitude,m.latitude,
ROUND(6378.138*2*asin(sqrt(pow(sin((m.latitude*pi()/180-39.964945*pi()/180)/2),2)+cos(m.latitude*pi()/180)*cos(39.964945*pi()/180)*pow(sin( (m.longitude*pi()/180-116.50028*pi()/180)/2),2)))*1000)
as distance
FROM `yc_merchant` as m
mysql 距离计算
最新推荐文章于 2023-08-28 18:25:20 发布