By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 10.3.32-MariaDB |
-- широта-долгота в гугл кординтатах
-- ОСЛО 59.871615914096544, 10.732875010123138
-- стокгольм 59.28192441905507, 18.082728206254334
-- аргумент Долгота-Широта а не наоборот
-- Только MariaDB функция ST_GeomFromText (без ЗПТ)
set @oslo = ST_GeomFromText('POINT(10.732875010123138 59.871615914096544)');
set @stok = ST_GeomFromText('POINT(18.082728206254334 59.28192441905507)');
SELECT ST_Distance_Sphere(@oslo, @stok) AS dist_Meter,
ST_Distance_Sphere(@oslo, @stok) / 1000 AS dist_KM;
-- MySQL
SELECT ST_Distance_Sphere(POINT(10.732875010123138, 59.871615914096544 )
, POINT(18.082728206254334, 59.28192441905507)) AS dist_Meter;
| dist_Meter | dist_KM |
|---|---|
| 418785.6180850169 | 418.7856180850169 |
| dist_Meter |
|---|
| 418785.6180850169 |