228 mysql 空间地理函数

参考链接

mysql 5.7.28 空间地理位置计算
https://blog.csdn.net/qq_32201423/article/details/103870040

SELECT
id,
st_distance_sphere (POINT (39.900966, 116.497202),
POINT ( longitude_gcj02, latitude_gcj02 )) AS distance
FROM
anjuke_poi_110100
HAVING
distance < 3000
ORDER BY
distance ASC;

Incorrect arguments to st_distance_sphere

SHOW VARIABLES LIKE ‘character_set%’;
SHOW VARIABLES LIKE 'collation%

SET character_set_client = utf8;
SET character_set_connection = utf8;
SET character_set_database = utf8;
SET character_set_results = utf8;
SET collation_connection = utf8_general_ci;
Numeric value out of range: 1264 Out of range value for column ‘housing_price’ at row 1