This documentation is for an older version. If you're using the most current version, select the documentation for that version with the version switch in the upper right corner of the online documentation, or by downloading a newer PDF or EPUB file.

MySQL has data types that correspond to OpenGIS classes. Some of these types hold single geometry values:

`GEOMETRY`

`POINT`

`LINESTRING`

`POLYGON`

`GEOMETRY`

can store geometry values of any
type. The other single-value types (`POINT`

,
`LINESTRING`

, and `POLYGON`

)
restrict their values to a particular geometry type.

The other data types hold collections of values:

`MULTIPOINT`

`MULTILINESTRING`

`MULTIPOLYGON`

`GEOMETRYCOLLECTION`

`GEOMETRYCOLLECTION`

can store a collection of
objects of any type. The other collection types
(`MULTIPOINT`

,
`MULTILINESTRING`

,
`MULTIPOLYGON`

, and
`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.3, “Using Spatial Data”.