Syntax
------

ST_GeomCollFromText(wkt[,srid])
ST_GeometryCollectionFromText(wkt[,srid])
GeomCollFromText(wkt[,srid])
GeometryCollectionFromText(wkt[,srid])

Description
-----------

Constructs a GEOMETRYCOLLECTION value using its WKT representation and SRID.

ST_GeomCollFromText(), ST_GeometryCollectionFromText(), GeomCollFromText() and
GeometryCollectionFromText() are all synonyms.

Example
-------

CREATE TABLE gis_geometrycollection  (g GEOMETRYCOLLECTION);
SHOW FIELDS FROM gis_geometrycollection;
INSERT INTO gis_geometrycollection VALUES
  (GeomCollFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10
10))')),
  (GeometryFromWKB(AsWKB(GeometryCollection(Point(44, 6),
LineString(Point(3, 6), Point(7, 9)))))),
  (GeomFromText('GeometryCollection()')),
  (GeomFromText('GeometryCollection EMPTY'));

URL: https://mariadb.com/kb/en/st_geomcollfromtext/