我正在尝试将多边形的地理坐标插入到我的 MySQL 数据库中。我有一个名为 POLYGON 类型的 Polygon 字段,并且我已尝试运行所有这些查询,但仍然出现 SQL 语法错误:
SET @g = 'POLYGON((-74.13591384887695 40.93750722242824,-74.13522720336914 40.929726129575016,-74.15102005004883 40.9329683629703,-74.14329528808594 40.94256444133327))';
INSERT INTO 'zones' ('polygon') VALUES (PolyFromText(@g));
INSERT INTO 'zones' ('polygon') VALUES (PolyFromText('POLYGON((-74.13591384887695 40.93750722242824,-74.13522720336914 40.929726129575016,-74.15102005004883 40.9329683629703,-74.14329528808594 40.94256444133327))'));
INSERT INTO 'zones' ('polygon') VALUES (PolyFromText('POLYGON((-74.13591384887695 40.93750722242824,-74.13522720336914 40.929726129575016,-74.15102005004883 40.9329683629703,-74.14329528808594 40.94256444133327))', 0));
最后一个查询是使用 phpmyadmins 自己的地理空间工具生成的,并返回“列‘多边形’不能为空”。任何帮助表示赞赏!