mysql 下计算 经纬度距离

MySQL 5.7.6 下新增函数 ST_Distance_Sphere
 

示例一:
mysql> SET @pt1 = ST_GeomFromText('POINT(0 0)');
mysql> SET @pt2 = ST_GeomFromText('POINT(180 0)');
mysql> SELECT ST_Distance_Sphere(@pt1, @pt2);
+--------------------------------+
| ST_Distance_Sphere(@pt1, @pt2) |
+--------------------------------+
|             20015042.813723423 |
+--------------------------------+

示例二:
select ST_Distance_Sphere(point (121.53968811 , 29.87466204),point(121.56560898,29.86863341));

 

转载于:https://my.oschina.net/jeebey/blog/1933146