https://dev.mysql.com/gis-linestring-property-functions.html
You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. Unless otherwise specified, functions in this section handle their arguments as follows: If any argument is NULL or any geometry ...
https://dev.mysql.com/gis-class-linestring.html
A LineString is a Curve with linear interpolation between points. LineString Examples On a world map, LineString objects could represent rivers. LineString Properties A LineString has coordinates of segments, defined by each consecutive pair of ...
https://dev.mysql.com/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/spatial-convenience-functions.html
The functions in this section provide convenience operations on geometry values. Unless otherwise specified, functions in this section handle their arguments as follows: If any argument is NULL, the return value is NULL. If any geometry argument is ...
https://dev.mysql.com/gis-format-conversion-functions.html
MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping the order of X and Y coordinates. There are also functions to convert a string from WKT or WKB ...
https://dev.mysql.com/gis-general-property-functions.html
The functions listed in this section do not restrict their argument and accept a geometry value of any type. Unless otherwise specified, functions in this section handle their arguments as follows: If any argument is NULL, the return value is NULL.
https://dev.mysql.com/spatial-operator-functions.html
OpenGIS proposes a number of functions that can produce geometries. These functions support all argument type combinations except those that are inapplicable according to the Open Geospatial Consortium specification. Unless otherwise specified, ...
https://dev.mysql.com/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
