简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

MYSQL 关于两个经纬度之间的距离由近及远排序_MySQL

WBOY
Release： 2016-06-01 13:25:12
Original
1259 people have browsed it

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

Related labels：
Latitude and longitude
source：php.cn
Previous article：深入理解SQL的四种连接-左外连接、右外连接、内连接、全连接_MySQL Next article：解决MYSQL出现Can't create/write to file '#sql_5c0_0.MYD'_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
Content overflow in window prevents scrolling and hides new content I'm currently building a roulette system program (this is more to stop me from placing bet...
From 2024-04-03 21:24:55
0
1
285
How to make animation pause on hover but continue once mouse leaves I've tired of several solutions and this is the closest I've gotten. But I'm still not hap...
From 2024-04-01 09:43:54
0
1
349
Limit height of collapsed accordion segments Bootstrap 5 Vue3 I'm building a web application using Vue3 and bootstrap5. But I think this question only c...
From 2024-03-31 21:56:54
0
1
332
Mysql query returns too slowly I have written a query. It works better. But currently, all tables have 100K rows, and one...
From 2024-03-30 18:25:44
0
1
366
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！