PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. MySQL also supports a native JSON data type and a set of SQL functions to enable operations on JSON values. For more information, see Section 11.5, “The ...Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from ...
https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html
Table 12.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). Also beginning with MySQL 5.7.22: “pretty-printing” of JSON values in an easy-to-read format can be ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-plugin-specific.html
For each keyring plugin-specific function, this section describes its purpose, calling sequence, and return value. For information about general-purpose keyring functions, see Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”.
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
Note There is also an IF statement, which differs from the IF() function described here. If only one of expr2 or expr3 is explicitly NULL, the result type of the IF() function is the type of the non-NULL expression. The default return type of IF() ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
There are also functions to convert a string from WKT or WKB format to internal geometry format. MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format. See Section ...
https://dev.mysql.com/doc/refman/5.7/en/gis-wkt-functions.html
These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier (SRID). Other functions provide type-specific construction functions for construction of geometry values of each ...
https://dev.mysql.com/doc/refman/5.7/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/5.7/en/gis-property-functions.html
Each function that belongs to this group takes a geometry value as its argument and returns some quantitative or qualitative property of the geometry. Such functions return NULL if the argument is of an incorrect geometry type. For example, the ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions.html
The functions described in this section take two geometries as arguments and return a qualitative or quantitative relation between them. MySQL implements two sets of functions using function names defined by the OpenGIS specification. There is also ...One set tests the relationship between two geometry values using precise object shapes, the other set uses object minimum bounding rectangles ...
https://dev.mysql.com/doc/refman/5.7/en/gis-linestring-property-functions.html
(There is an existing SQL function Length() that calculates the length of string values.) GLength() is deprecated; expect it to be removed in a future MySQL release. You can extract particular points of a LineString, count the number of points that ...EndPoint() is deprecated; expect it to be removed in a future MySQL ...