MySQL tutorial: GEOMETRYCOLLECTION [EN]
top of page
CerebroSQL

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