MySQL之空间函数**ST_Distance_Sphere
MySQL之空间函数ST_Distance_Sphere
用来计算两个经纬度之间的球体距离
SELECT ST_Distance_Sphere(POINT(116.4025249,39.9251859),POINT(116.4025249,39.9250644)) AS distant;
上述算出的单位是米
接下来尝试一下建表
CREATE TABLE `map` (
`id` int(11) NOT NULL,
`address` varchar(255) NOT NULL DEFAULT '',
原创
2020-05-19 18:19:30 ·
2231 阅读 ·
0 评论