PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.4Kb
Man Pages (Zip)
- 360.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/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. There are also functions to convert a string from WKT or WKB format to internal geometry format. See Section ...
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/json-creation-functions.html
The functions listed in this section compose JSON values from component elements. This function is typically used to produce a valid JSON string literal for inclusion within a JSON document. Two aggregate functions generating JSON values are ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. The functions described in this section are MySQL extensions to the OpenGIS specification. These functions produce geometry objects from either WKB values or ...If ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
Table 12.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...A ...
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 second syntax returns the ...
https://dev.mysql.com/doc/refman/5.7/en/gis-general-property-functions.html
The functions listed in this section do not restrict their argument and accept a geometry value of any type. ST_IsEmpty(g) This function is a placeholder that returns 0 for any valid geometry value, 1 for any invalid geometry value, or NULL if the ...Dimension() is deprecated; expect it to be removed in a future MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/gis-polygon-property-functions.html
Functions in this section return properties of Polygon or MultiPolygon values. This function processes geometry collections by computing the centroid point for components of highest dimension in the collection. Area() is deprecated; expect it to be ...