鱼油软胶囊
记叙文万能事例mysql 经纬度距离计算
经纬度距离计算
函数计算⽅法
两点距离(单位m) mysql 5.6 添加两点球⾯距离(单位m )MySQL 5.7.6添加CREATE DEFINER=`root`@`%` FUNCTION `GetDistance`( myLatitude DECIMAL(11,8),#我当前位置的纬度 myLongitude DECIMAL(11,8),#我当前位置的经度 latitude DECIMAL(11,8), Longitude DECIMAL(11,8) ) RETURNS double BEGIN RETURN round( 6370986 * ACOS( COS(RADIANS(myLatitude)) * COS(RADIANS(latitude)) * COS(RADIANS(Longitude) - RADIANS(myLongitude)) + SIN(RADIANS(myLatitude)) * SIN(RADIANS(latitude)) )/1000,2 );END
1
2
3
4
东南亚游
5
6
红烧猪肘子7
8
9
10
暖宫贴11
12
13
14lect st_distance(point(0,0),point(1,1));lect st_distance(point (120.10591, 30.30163),point(120.13026,30.25961));1
采购框架协议
2lect st_distance_sphere(point(0,0),point(1,1));lect st_distance_sphere(point (120.10591, 30.30163),point(120.13026,30.25961));1
2文心出版社
>分书