方式1：st_distance_sphere
st_distance_sphere函数返回以米为单位
SELECT
*,st_distance_sphere (
point ( longitudes, latitudes ),
point ( 113.264435, 23.129163 )) AS juli
FROM
zxh_distance
ORDER BY
juli ASC;
方式2：st_distance
st_distance返回的度
st_distance 计算的结果单位是度，需要乘111195（地球半径6371000*PI/180）是将值转化为米。
SELECT
*,st_distance (
point ( longitudes, latitudes ),
point ( 113.264435, 23.129163 )) AS juli
FROM
zxh_distance
ORDER BY
juli ASC;
方式3 直接计算
SELECT
*,ROUND(
6378.138 * 2 * ASIN(
SQRT(
POW( SIN(( 23.129163 * PI()/ 180-latitudes * PI()/ 180 )/ 2 ), 2 )+ COS( 23.129163 * PI()/ 180 )* COS( latitudes * PI()/ 180 )* POW( SIN(( 113.264435 * PI()/ 180-longitudes * PI()/ 180 )/ 2 ), 2 )))* 1000
) AS juli
FROM
zxh_distance
ORDER BY
juli ASC
原文链接：https://blog.csdn.net/qq_39632561/article/details/119949634
st_distance_sphere原文:https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
st_distance原文：https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html#function_st-distance
