Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/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 arguments as follows: If any argument is NULL, the return value is ...
https://dev.mysql.com/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/point-in-time-recovery.html
Point-in-time recovery refers to recovery of data changes made since a given point in time. (The full backup can be made in several ways, such as those listed in Section 7.2, “Database Backup Methods”.) Point-in-time recovery then brings the ...
https://dev.mysql.com/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/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/point-in-time-recovery-times.html
To use this method of point-in-time recovery, you should examine the log to be sure of the exact times to specify for the commands. To indicate the start and end times for recovery, specify the --start-datetime and --stop-datetime options for ...
https://dev.mysql.com/point-in-time-recovery-positions.html
Instead of specifying dates and times, the --start-position and --stop-position options for mysqlbinlog can be used for specifying log positions. They work the same as the start and stop date options, except that you specify log position numbers ...
https://dev.mysql.com/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/spatial-operator-functions.html
These spatial operator functions are available: ST_Buffer(g, d[, strategy1[, strategy2[, strategy3]]]) Returns a geometry that represents all points whose distance from the geometry value g is less than or equal to a distance of d. If the distance ... OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/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 ...This backup should be updated regularly—perhaps even hourly—depending on your ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-point-p-1.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
