MySQL supports a variety of data types to support and store different kind of data and to perform different operations on it.

Supported data types can be majorly categorized into following types:

Spatial Types

Spatial types are used to store geographical and geometrical data in structured manner.

Following spatial types are accepted:

  • GEOMETRY: It is used to store spatial values of any type.
  • POINT: It is used to store a point (a pair of X Y coordinates).
  • LINESTRING: It is used to store a curve (one or more POINT values).
  • POLYGON: It is used to store polygons.
  • GEOMETRYCOLLECTION: It is used to store a collection of GEOMETRY values.
  • MULTILINESTRING: It is used to store a collection of LINESTRING values.
  • MULTIPOINT: It is used to store a collection of POINT values.
  • MULTIPOLYGON: It is used to store a collection of POLYGON values.