java mysql根据经纬度获取距离
DELIMITER $$
DROP FUNCTION IF EXISTS `fun_distance`$$
CREATE FUNCTION `fun_distance`(lat1 float,lng1 float,lat2 float,lng2 float) RETURNS float
BEGIN
set @num=6371.229*2*ASIN(SQRT(POW(SIN((lat1*PI
原创
2016-03-10 17:43:50 ·
948 阅读 ·
1 评论