mysql语句

SELECT (st_distance (point (coordinateLng, coordinateLat),point(113.858202,22.583819) ) / 0.0111) AS distance 
,heitht FROM`wtsr_lose_people` HAVING distance<800 ORDER BY distance

posted @ 2018-10-19 15:16  慧妃不美  阅读(91)  评论(0编辑  收藏  举报