SELECT a.address,
CONVERT(IFNULL(( st_distance ( point ( a.longitude, a.latitude ), point ( #{longitude}, #{latitude} ))* 111195 ), 99999), DECIMAL(10,2)) AS distance +
FROM
t_address a
sql 查询两点之间的距离
最新推荐文章于 2024-03-24 21:01:24 发布