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/