GEOMETRYCOLLECTIONFROMTEXT()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
EXAMPLES
SET @g = 'GEOMETRYCOLLECTION(POINT(1 0),LINESTRING(0 1,1 1,1 2,2 3,3 4))';
SELECT ST_AsText(GEOMETRYCOLLECTIONFROMTEXT(@g));
+----------------------------------------------------------------+
| ST_AsText(GEOMETRYCOLLECTIONFROMTEXT(@g)) |
+----------------------------------------------------------------+
| GEOMETRYCOLLECTION(POINT(1 0),LINESTRING(0 1,1 1,1 2,2 3,3 4)) |
+----------------------------------------------------------------+
CREATE TABLE t (c1 GEOMETRYCOLLECTION);
SET @g = 'GEOMETRYCOLLECTION(POINT(1 0),LINESTRING(0 1,1 1,1 2,2 3,3 4))';
INSERT INTO t VALUES (GEOMETRYCOLLECTIONFROMTEXT(@g));
SELECT ST_AsText(c1) FROM t;
+----------------------------------------------------------------+
| ST_AsText(c1) |
+----------------------------------------------------------------+
| GEOMETRYCOLLECTION(POINT(1 0),LINESTRING(0 1,1 1,1 2,2 3,3 4)) |
+----------------------------------------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.