Mysql 根据经纬度计算距离函数

最新推荐文章于 2024-05-31 17:29:33 发布

weixin_34242819

最新推荐文章于 2024-05-31 17:29:33 发布

阅读量628

点赞数

文章标签：数据库 python java

原文链接：https://my.oschina.net/u/2611678/blog/1843740

版权

2019独角兽企业重金招聘Python工程师标准>>>

CREATE DEFINER=`root`@`%` FUNCTION `getDistance`(`lon1` double,`lat1` double,`lon2` double,`lat2` double) RETURNS varchar(200) CHARSET utf8mb4
BEGIN
declare vLon1,vLat1,vLon2,vLat2,distance,vShortLon,vShortLat double;
declare vRlt double;
set vLon1 = lon1;
set vLat1 = lat1;

set vlon2 = lon2;
set vLat2 = lat2;
set vRlt = 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((lon1 * PI() / 180 - lon2 * PI() / 180) / 2),2))) * 1000
);

return vRlt;

RETURN '';
END;

select getDistance(116.32793,39.94607,121.42575,31.24063);

转载于:https://my.oschina.net/u/2611678/blog/1843740