Pre-General Availability Draft: 2017-08-20
MySQL has data types that correspond to OpenGIS classes. Some of these types hold single geometry values:
GEOMETRY can store geometry values of any
type. The other single-value types (
restrict their values to a particular geometry type.
The other data types hold collections of values:
GEOMETRYCOLLECTION can store a collection of
objects of any type. The other collection types
GEOMETRYCOLLECTION) restrict collection
members to those having a particular geometry type.
MySQL spatial data types have their basis in the OpenGIS geometry model, described in Section 11.5.2, “The OpenGIS Geometry Model”. For examples showing how to use spatial data types in MySQL, see Section 11.5.5, “Creating Spatial Columns”.