PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the ST_X() and ST_Y() functions, respectively. These functions also permit an optional second argument that specifies an X or Y coordinate value, in which case the function result ...Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value is ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html
The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a point-in-time-recovery. You can perform a point-in-time recovery to restore the server up to its state ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-point.html
A Point is a geometry that represents a single location in coordinate space. Point Examples Imagine a large-scale map of the world with many cities. On a city map, a Point object could represent a bus stop.
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-binlog.html
This section explains the general idea of using the binary log to perform a point-in-time-recovery. The next section, Section 9.5.2, “Point-in-Time Recovery Using Event Positions”, explains the operation in details with an example. The source ...Note Many of the examples in this and the next section use the mysql client to process binary log output produced by ...
https://dev.mysql.com/doc/refman/8.0/en/fixed-point-types.html
The precision represents the number of significant digits that are stored for values, and the scale represents the number of digits that can be stored following the decimal point. If the scale is 0, DECIMAL values contain no decimal point or ... The ...
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
Here, (M,D) means than values can be stored with up to M digits in total, of which D digits may be after the decimal point. Because floating-point values are approximate and not stored as exact values, attempts to treat them as exact in comparisons ... The FLOAT and DOUBLE types represent approximate numeric data ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
Point-in-time recovery refers to recovery of data changes up to a given point in time. (The full backup can be made in several ways, such as those listed in Section 9.2, “Database Backup Methods”.) Point-in-time recovery then brings the server ...Typically, this type of recovery is performed after restoring a full backup that brings the server to its state as of the time the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
See that section for descriptions of these functions: ST_Envelope(g) ST_StartPoint(ls) ST_EndPoint(ls) ST_PointN(ls, N) ST_ExteriorRing(poly) ST_InteriorRingN(poly, N) ST_GeometryN(gc, N) Unless otherwise specified, functions in this section handle ... OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/doc/refman/8.0/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 ...The ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
If the optional M and D values are given, they specify the maximum number of digits (the precision) and the number of digits following the decimal point (the scale). Conditions for Casts to Point When the cast result type is Point, these conditions ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string 8.0.27 CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...