且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用MySQL空间查询查找X半径内的所有记录?

更新时间:2023-02-17 17:46:08

它无法正常工作,因为MySQL尚未实际实现实现此目的的代码.他们只使用边界框查询.

It won't work because MySQL hasn't actually implemented the code to make this work. They only use bounding box queries.

请注意,此处未列出任何功能: http: //dev.mysql.com/doc/refman/5.5/zh-CN/functions-for-testing-spatial-relations-between-geometric-objects.html

Notice there are no functions listed here: http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html

我建议改用PostGIS或Spatialite.

I would reccomend using PostGIS or Spatialite instead.