最近我一直在尝试从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 |
...
暂无答案!
目前还没有任何答案,快来回答吧!