MySQL/Language/Spatial databases

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] ttp://dev.mysql.com/doc/refman/5.0/en/spatial-datatypes.html

[2] ttp://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-mbr.html

[1]

[2]