Search Results
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/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. A floating-point value as written in an SQL statement may not be the same as the value represented internally. Attempts to treat ...
https://dev.mysql.com/doc/internals/en/floating-point-types.html
The MySQL Reference Manual has a discussion of floating-point numbers in Section 11.2 Numeric Types, including details about the storage. Let us now take up the story from where the MySQL Reference Manual leaves off. The following discussion ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-pitr.html
Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was made. Performing point-in-time recovery of NDB Cluster ...
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/replication-features-floatvalues.html
With statement-based replication, values are converted from decimal to binary. Because conversions between decimal and binary representations of them may be approximate, comparisons involving floating-point values are inexact. This is true for ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/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.