DELIMITER $$
USE `xx`$$
DROP FUNCTION IF EXISTS `getDistance`$$
CREATE DEFINER=`xx`@`%` FUNCTION `getDistance`(curLat DOUBLE,curLon DOUBLE,shopLat DOUBLE,shopLon DOUBLE) RETURNS DOUBLE
BEGIN
DECLARE dis DOUBLE;
SET dis = ACOS(SIN((curLat * 3.1415) / 180 ) * SIN((shopLat * 3.1415) / 180 ) + COS((curLat * 3.1415) / 180 ) * COS((shopLat * 3.1415) / 180 ) * COS((curLon * 3.1415) / 180 - (shopLon * 3.1415) / 180 ) ) * 6380 ;
SET dis = ROUND(dis*1000,2);
RETURN dis;
END$$
DELIMITER ;
mysql 通过经纬度计算距离
最新推荐文章于 2024-08-06 18:14:18 发布