mysql 两点间距离_MySQL实现计算两点之间的距离

DELIMITER $$

CREATE FUNCTION `calculateLineDistance`(startLng double, startLat double, endLng double, endLat double) RETURNS double

BEGIN

declare d2 DOUBLE;

declare d3 DOUBLE;

declare d4 DOUBLE;

declare d5 DOUBLE;

declare d6 DOUBLE;

declare d7 DOUBLE;

declare d8 DOUBLE;

declare d9 DOUBLE;

declare d10 DOUBLE;

declare d11 DOUBLE;

declare d12 DOUBLE;

declare d13 DOUBLE;

declare d14 DOUBLE;

declare arrayOfDouble10 DOUBLE;

declare arrayOfDouble11 DOUBLE;

declare arrayOfDouble12 DOUBLe;

declare arrayOfDouble20 DOUBLE;

declare arrayOfDouble21 DOUBLE;

declare arrayOfDouble22 DOUBLE;

set d2 = startLng * 0.01745329251994329;

set d3 = startLat * 0.01745329251994329;

set d4 = endLng * 0.01745329251994329;

set d5 = endL