PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
The fifth number is an IEEE 802 node number that provides spatial uniqueness. The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode.
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
Explicitly specified ASC and DESC designators for HASH, FULLTEXT, and SPATIAL indexes results in an error. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order.
https://dev.mysql.com/doc/refman/8.0/en/json.html
A set of spatial functions for operating on GeoJSON values is also available. The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON ...
https://dev.mysql.com/doc/refman/8.0/en/json-functions.html
A set of spatial functions for operating on GeoJSON values is also available. The functions described in this section perform operations on JSON values. For discussion of the JSON data type and additional examples showing how to use these ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? A.16.2. How much space does InnoDB use for the change buffer? A.16.5. How do I determine the current size of the change buffer? A.16.6. Where can I find additional ...
https://dev.mysql.com/doc/refman/8.0/en/gis-geometrycollection-property-functions.html
If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions-and-modifiers.html
For information about aggregate functions that operate on geometry values, see Section 14.16.12, “Spatial Aggregate Functions”. They are often used with a GROUP BY clause to group values into subsets.
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview and more detailed description of the properties of ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
CHECK TABLE functionality for InnoDB SPATIAL indexes includes an R-tree validity check and a check to ensure that the R-tree row count matches the clustered index. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE ...