将多边形插入mysql数据库时出现问题

发布于 2024-11-17 14:47:06 字数 764 浏览 2 评论 0原文

我尝试将

PolygonFromText("POLYGON((121.44842136764532 31.22119260287111,
                          121.45076025390631 31.221990825071376,
                          121.45402182006842 31.218366658611853,
                          121.45091045761114 31.217054584347302))")

值插入到多边形类型和几何类型的字段中。

当我运行时，

SELECT PolygonFromText("POLYGON((121.44842136764532 31.22119260287111,
                                 121.45076025390631 31.221990825071376,
                                 121.45402182006842 31.218366658611853,
                                 121.45091045761114 31.217054584347302))")

它返回 NULL

My Mysql Version is 5.1.41 - 我发现 MySql 文档非常差，在这些情况下对用户不友好

原文

I tried inserting

PolygonFromText("POLYGON((121.44842136764532 31.22119260287111,
                          121.45076025390631 31.221990825071376,
                          121.45402182006842 31.218366658611853,
                          121.45091045761114 31.217054584347302))")

as a value into a a field of both type Polygon and of type Geometry.

When I run

SELECT PolygonFromText("POLYGON((121.44842136764532 31.22119260287111,
                                 121.45076025390631 31.221990825071376,
                                 121.45402182006842 31.218366658611853,
                                 121.45091045761114 31.217054584347302))")

it returns NULL

My Mysql Version is 5.1.41 - I find the MySql documentation very poor and not user friendly in these cases

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

岁月流歌 2024-11-24 14:47:06

我认为多边形必须闭合，因此最后一组坐标应与第一组坐标相同。这将返回以下

SELECT  PolygonFromText("POLYGON((121.44842136764532 31.22119260287111,121.45076025390631 31.221990825071376,121.45402182006842 31.218366658611853,121.45091045761114 31.217054584347302,121.44842136764532 31.22119260287111))");

I think a Polygon has to close so the last set of coordinates should be same as first one. This will return following

SELECT  PolygonFromText("POLYGON((121.44842136764532 31.22119260287111,121.45076025390631 31.221990825071376,121.45402182006842 31.218366658611853,121.45091045761114 31.217054584347302,121.44842136764532 31.22119260287111))");

回复收藏 0 原文

~没有更多了~