MYSQL 关于两个经纬度之间的距离由近及远排序_MySQL
- WBOYOriginal
- 2016-06-01 13:25:121295browse
bitsCN.com
select *,(2 * 6378.137* ASIN(SQRT(POW(SIN(PI()*(111.86141967773438-lat)/360),2)+COS(PI()*33.07078170776367/180)* COS(lat * PI()/180)*POW(SIN(PI()*(33.07078170776367-lng)/360),2)))) as juli from `area`
order by juli asc limit 0,20
差不多就是这样的,做个记录
但是我觉得这样还是很慢，因为我的坐标都是通过百度获取的，我的想法是能够转成平面坐标更好，这样更好计算
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：深入理解SQL的四种连接-左外连接、右外连接、内连接、全连接_MySQLNext article：解决MYSQL出现Can't create/write to file '#sql_5c0_0.MYD'_MySQL