当前位置:Gxlcms > mysql > MySQL5.6将对空间字段geometry运算全面支持_MySQL

MySQL5.6将对空间字段geometry运算全面支持_MySQL

时间:2021-07-01 10:21:17 帮助过:9人阅读

bitsCN.com

还是做数据库迁移。

还是从MSSQL迁移到MySQL,数据迁移过去了,最大的问题就在于MySQL不支持空间运算。最初我的打算是用MySQL连接C,然后用C去连接Postgres,然后由Postgres的Postgis插件运算后,返回结果。纠结了两天,堆了一天代码失败,返回始终为NULL,万般无奈下,翻看MySQL文档,查到在5.6中即将支持精确的空间运算,十分高兴,立马下载其测试版,试用,果然好用。纠结结束,分享链接:

http://dev.mysql.com/doc/refman/5.6/en/functions-for-testing-spatial-relations-between-geometric-objects.html

注意其中的NOTE,亮点在于:

NoteMySQL originally implemented these functions such that they used object bounding rectangles and returned the same result as the corresponding MBR-based functions. As of MySQL 5.6.1, corresponding versions are available that use precise object shapes. These versions are named with an ST_ prefix. For example, Contains() uses object bounding rectangles, whereas ST_Contains() uses object shapes.As of MySQL 5.6.1, there are also ST_ aliases for existing spatial functions that were already exact. For example,ST_IsEmpty() is an alias for IsEmpty() bitsCN.com

人气教程排行