set @lat1=108.887182;
set @lat2=108.95723;
set @lng1=34.178259;
set @lng2=34.373428;
SELECT 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);
-----------------------------------------------------------------------------------------------------------------
创建函数
CREATE FUNCTION `getDistance`(`lat1` decimal(10,6),`lng1` decimal(10,6),`lat2` decimal(10,6),`lng2` decimal(10,6)) RETURNS int(11)
BEGIN
/*
功能:通过2个点经纬度获取距离
作者:张维斌、
示例:
set @lat1=108.887182;
set @lat2=108.95723;
set @lng1=34.178259;
set @lng2=34.373428;
SELECT getDistance(@lat1,@lng1,@lat2,@lng2);
单位:米
*/
RETURN 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);
END