< MySQL < Language

Principle

When typing the fields, some of them represent graphical objects, and so are considered like as "Spatial". Consequently, they are manipulated by some different request than for the text.

We distinguish eight fields types[1]:

  • Geometry
  • Point
  • LineString
  • Polygon
  • MultiPoint
  • MultiLineString
  • MultiPolygon
  • GeometryCollection

And six relations between them[2]:

  • Contains
  • Disjoint
  • Equals
  • Intersects
  • Overlaps
  • Within

Requests

References

  1. ↑ http://dev.mysql.com/doc/refman/5.0/en/spatial-datatypes.html
  2. ↑ http://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-mbr.html
This article is issued from Wikibooks. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.