mysql 通过经纬度计算距离

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 ;