How to deal with longitude and latitude distance of geometry type in MySQL

This article is about how the geometry type in MySQL deals with longitude and latitude distances. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Build a table

CREATE TABLE `map` (`id` int (11) NOT NULL, `address` varchar (255) NOT NULL DEFAULT'', `location` geometry NOT NULL, PRIMARY KEY (`id`), SPATIAL KEY `location` (`location`))

insert

INSERT INTO map (id, address, location) VALUES (1, 'somewhere', ST_GeomFromText (' POINT (121.366961 31.190049)'); note that the ST_GeomFromText function must be used, and POINT () contains longitude + space + latitude query 1. View SELECT address, ST_AsText (location) AS location FROM map;2. The distance between two points is calculated by SELECT ST_Distance_Sphere (POINT (121.590347, 31.388094), location) AS distant FROM map;, in meters.

Notice that the latitude and longitude in POINT () is now a comma-separated 3. Query sites with a distance of less than 1000m, and sort by SELECT id, address, ST_Distance_Sphere (POINT (121.590347, 31.388094), location) AS distant FROM map WHERE ST_Distance_Sphere (POINT (121.590347, 31.388094), location) < 1000 ORDER BY distant; thank you for reading! On MySQL geometry type how to deal with longitude and latitude distance is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.