ST_GEOMCOLLFROMTEXT

База данных: MySQL

68747470733a2f2f7374796c65732e7265646469746d656469612e636f6d2f74355f32716d366b2f7374796c65

ST_GeomCollFromText(wkt[, srid [, options]]),
ST_GeometryCollectionFromText(wkt[, srid [, options]]),
ST_GeomCollFromTxt(wkt[, srid [, options]])

Constructs a GeometryCollection value using its WKT representation and
SRID.

These functions handle their arguments as described in the introduction
to this section.

URL: https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html

Example

mysql> SET @g = "MULTILINESTRING((10 10, 11 11), (9 9, 10 10))";
mysql> SELECT ST_AsText(ST_GeomCollFromText(@g));
+--------------------------------------------+
| ST_AsText(ST_GeomCollFromText(@g)) |
+--------------------------------------------+
| MULTILINESTRING((10 10,11 11),(9 9,10 10)) |
+--------------------------------------------+