我想创建一个mysql函数,用于计算两个地理编码之间的haversine距离。
CREATE FUNCTION haversineDistance
(
lat1 VARCHAR(256),
long1 VARCHAR(256),
lat2 VARCHAR(256),
long2 VARCHAR(256)
)
RETURNS FLOAT DETERMINISTIC
BEGIN
DECLARE radLat1 FLOAT;
DECLARE radLong1 FLOAT;
DECLARE radLat2 FLOAT;
DECLARE radLong2 FLOAT;
DECLARE dLat FLOAT;
DECLARE dLong FLOAT;
DECLARE cordLength FLOAT;
DECLARE centralAngle FLOAT;
DECLARE distance FLOAT;
SET radLat1 = CAST(lat1 AS FLOAT) * PI() / 180;
SET radLong1 = CAST(long1 AS FLOAT) * PI() / 180;
SET radLat2 = CAST(lat2 AS FLOAT) * PI() / 180;
SET radLong2 = CAST(long2 AS FLOAT) * PI() / 180;
SET dLat = radLat2 - radLat1;
SET dLong = radLong2 - radLong2;
SET cordLength = POW(SIN(dLat/2),2)+COS(lat1)*COS(lat2)*POW(SIN(dLon/2),2);
SET centralAngle = 2 * ATAN2(SQRT(cordLength), SQRT(1-cordLength));
SET distance = 6367 * centralAngle;
RETURN distance;
END
但是我遇到了这样的错误:
1064 - SQL 语法错误;请查看与您的 MySQL 服务器版本对应的手册以获取正确的语法,第 4 行附近有问题
是否有任何想法?
提前感谢您。