mysql 空间数据库 寻找最近的坐标点
mybatis
select truncate(st_distance( POINT(#{Latitude},#{Longitude}), POINT(d.Latitude,d.Longitude) ) * 111195 / 1000,2) as distance
FROM x_map d
ORDER BY distance
LIMIT 0,50
mysql 空间数据库 寻找最近的坐标点
mybatis
select truncate(st_distance( POINT(#{Latitude},#{Longitude}), POINT(d.Latitude,d.Longitude) ) * 111195 / 1000,2) as distance
FROM x_map d
ORDER BY distance
LIMIT 0,50