我有一个MySQL 8表,它有一个名为";坐标";类型为";多边形";。
我正试图在其中插入一组坐标,就像这样:
INSERT INTO contract (coordinates)
VALUES (POLYGON(
(34.786166422784426, 32.162676265661624),
(34.720248454034426, 32.01024096292725),
(34.816378825128176, 31.973162105505374),
(34.86993717473755, 32.1338371543335),
(34.786166422784426, 32.162676265661624))
)
这给了我一个";列计数与第1行的值计数不匹配";错误
为什么会这样?如何正确格式化此查询?我如何用它明确地传递ESRI?
顺便说一句,这很好:
INSERT INTO contract (coordinates, smart_contract_version_id)
VALUES (ST_GeomFromText('POLYGON(( 34.786166422784426 32.162676265661624 , 34.720248454034426 32.01024096292725 , 34.816378825128176 31.973162105505374 , 34.86993717473755 32.1338371543335 , 34.786166422784426 32.162676265661624 ))', 4326), 1)
您插入错误。。你不需要那些家长。。请注意,双括号是有意的。。并且X/Y用空格表示。。不是逗号。如果它在没有";双parens";这是因为你没有任何镶嵌物;孔";等
POLYGON((
34.786166422784426 32.162676265661624,
34.720248454034426 32.01024096292725,
34.816378825128176 31.973162105505374,
34.86993717473755 32.1338371543335,
34.786166422784426 32.162676265661624
))