Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/spatial-geohash-functions.html
If any point argument does not have SRID 0 or 4326, an ER_SRS_NOT_FOUND error occurs. These geohash functions are available: ST_GeoHash(longitude, latitude, max_length), ST_GeoHash(point, max_length) Returns a geohash string in the connection ...
https://dev.mysql.com/writing-full-text-plugins.html
Each general plugin descriptor in the library descriptor points to a type-specific descriptor. The init and deinit members should point to a function or be set to 0 if the function is not needed. The parse member must point to the function that ...
https://dev.mysql.com/backup-types.html
These provide logical copies of the file system at a given point in time, without requiring a physical copy of the entire file system. Full Versus Incremental Backups A full backup includes all data managed by a MySQL server at a given point in time. An incremental backup consists of the changes made to the data during a given time span (from one point in time to ...
https://dev.mysql.com/binary-log.html
These events bring databases up to date from the point of the backup. For more information about the binary log and recovery operations, see Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”. At that point, mysqld writes ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/gis-wkb-functions.html
To migrate calls from using geometry arguments to using WKB arguments, follow these guidelines: Rewrite constructs such as ST_GeomFromWKB(Point(0, 0)) as Point(0, 0). Rewrite constructs such as ST_GeomFromWKB(Point(0, 0), 4326) as ST_SRID(Point(0, ... These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. For example, 2.34 is an exact-value (fixed-point) number, whereas 2.34E0 is an approximate-value (floating-point) number. The ...
https://dev.mysql.com/populating-spatial-columns.html
For example: Inserting a POINT(1 1) value with hex literal syntax: INSERT INTO geom VALUES (ST_GeomFromWKB(X'0101000000000000000000F03F000000000000F03F')); An ODBC application can send a WKB representation, binding it to a placeholder using an ...
https://dev.mysql.com/server-system-variables.html
For a description of the Debug Sync facility and how to use synchronization points, see MySQL Internals: Test Synchronization. When Block Nested-Loop is used, a larger join buffer can be beneficial up to the point where all required columns from all ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/spatial-geojson-functions.html
mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) | ... This section describes functions for ...
https://dev.mysql.com/start-slave.html
It is also possible with START SLAVE UNTIL to specify a stop point relative to a given GTID or set of GTIDs using one of the options SQL_BEFORE_GTIDS or SQL_AFTER_GTIDS, as explained previously in this section. If UNTIL is used on a multithreaded ...
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-4.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.
