Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns.html
The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math.html
MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control over invalid values. Precision math is based on these two features: SQL modes that control how strict the server ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-null.html
The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that NULL is the same thing as an empty string ''. For example, the following statements are completely different: mysql> INSERT INTO my_table ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". The functions in this section ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...
https://dev.mysql.com/doc/refman/8.4/en/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. MySQL also implements certain ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-mbr.html
MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and g2. The return values 1 and 0 indicate true and false, respectively. The MBR (also known as the bounding ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-object-shapes.html
The OpenGIS specification defines the following functions to test the relationship between two geometry values g1 and g2, using precise object shapes. The return values 1 and 0 indicate true and false, respectively, except that distance functions ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. DBAs can set the global SQL mode to match site server operating requirements, ...