top of page
MySQL:
GEOMETRYCOLLECTION
GeometryCollection(g [, g] ...)
Constructs a GeomCollection value from the geometry arguments.
GeometryCollection() returns all the proper geometries contained in the
arguments even if a nonsupported geometry is present.
GeometryCollection() with no arguments is permitted as a way to create
an empty geometry. Also, functions such as ST_GeomFromText() that
accept WKT geometry collection arguments understand both OpenGIS
'GEOMETRYCOLLECTION EMPTY' standard syntax and MySQL
'GEOMETRYCOLLECTION()' nonstandard syntax.
GeomCollection() and GeometryCollection() are synonymous, with
GeomCollection() the preferred function.
URL: https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html
Example
bottom of page