MySQL5.6支持3d点吗?

abithluo  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(347)

最近我一直在尝试从sqlite迁移到MySQL5.6(5.7在gis字段方面有问题)。我意识到我的3d点都没有导入mysql数据库,所以我进去手动尝试用django dumpdata输出更新行,但显然它不接受3d点,也没有给出任何警告或错误。
我应该切换到另一个数据库系统吗?我做错什么了吗?

mysql> UPDATE entrance SET location=GeomFromText("POINT Z (32.077624 36.58562 123)") WHERE id=1;
Query OK, 0 rows affected (0.03 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> UPDATE entrance SET location=GeomFromText("POINT(32.077624 36.58562)") WHERE id=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SHOW COLUMNS FROM entrance;
+---------------------------+--------------+------+-----+---------+----------------+
| Field                     | Type         | Null | Key | Default | Extra          
|
+---------------------------+--------------+------+-----+---------+----------------+
...
| location                  | point        | YES  |     | NULL    |           
...

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题