mysql 空间数据库实战
坐标点三公里内
SELECT
d.UnitName,
round(st_distance_sphere(point(119.531003, 35.421986),point(d.Longitude, d.Latitude))/1000,3) as distance
FROM
x_shopmap d
LEFT JOIN x_typedatadiction datay ON datay.Id = d.ClassificationBig
LEFT JOIN x_typedatadiction datax
原创
2020-08-15 16:28:21 ·
184 阅读 ·
0 评论