MySQL 8.3 Release Notes
- 14.16.1 Spatial Function Reference
- 14.16.2 Argument Handling by Spatial Functions
- 14.16.3 Functions That Create Geometry Values from WKT Values
- 14.16.4 Functions That Create Geometry Values from WKB Values
- 14.16.5 MySQL-Specific Functions That Create Geometry Values
- 14.16.6 Geometry Format Conversion Functions
- 14.16.7 Geometry Property Functions
- 14.16.8 Spatial Operator Functions
- 14.16.9 Functions That Test Spatial Relations Between Geometry Objects
- 14.16.10 Spatial Geohash Functions
- 14.16.11 Spatial GeoJSON Functions
- 14.16.12 Spatial Aggregate Functions
- 14.16.13 Spatial Convenience Functions
MySQL provides functions to perform various operations on spatial data. These functions can be grouped into several major categories according to the type of operation they perform:
-
Functions that create geometries in various formats (WKT, WKB, internal)
-
Functions that convert geometries between formats
-
Functions that access qualitative or quantitative properties of a geometry
-
Functions that describe relations between two geometries
-
Functions that create new geometries from existing ones
For general background about MySQL support for using spatial data, see Section 13.4, “Spatial Data Types”.