PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/ldml-rules.html
Character Representation Characters named in LDML rules can be written literally or in \unnnn format, where nnnn is the hexadecimal Unicode code point value. Orderings are given as a set of rules that begin with a reset rule that establishes an ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/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 9.5, “Point-in-Time (Incremental) Recovery”. At that point, mysqld writes the entire transaction ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/group-replication-understanding-consistency-guarantees.html
Transaction Synchronization Points You configure a group's consistency guarantee based on the point at which you want to synchronize transactions across the group. To help you understand the concept, this section simplifies the points of ... In ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/spatial-aggregate-functions.html
The result is the narrowest MultiXxx or GeometryCollection value possible, with the result type determined from the non-NULL geometry arguments as follows: If all arguments are Point values, the result is a MultiPoint value. MySQL supports ...