mySql的缓冲区分析

最新推荐文章于 2024-07-14 21:45:53 发布

herogui

最新推荐文章于 2024-07-14 21:45:53 发布

阅读量1.1k

点赞数

本文链接：https://blog.csdn.net/herogui/article/details/46624611

版权

SET @point = 'POINT(-126 45)';
SET @radius = 245;

SET @bbox = CONCAT('POLYGON((',
X(@center) - @radius, ' ', Y(@center) - @radius, ',',
X(@center) + @radius, ' ', Y(@center) - @radius, ',',
X(@center) + @radius, ' ', Y(@center) + @radius, ',',
X(@center) - @radius, ' ', Y(@center) + @radius, ',',
X(@center) - @radius, ' ', Y(@center) - @radius, '))'
);

SELECT AsText(pnt)
FROM pnttest
WHERE Intersects(pnt, GeomFromText(@bbox) )
AND SQRT(POW( ABS( X(pnt) - X(@center)), 2) + POW( ABS(Y(pnt) - Y(@center)), 2 )) < @radius;