PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-multipolygon.html
A MultiPolygon has no two Polygon elements that cross (crossing is also forbidden by the previous assertion), or that touch at an infinite number of points. A MultiPolygon boundary is a set of closed curves (LineString values) corresponding to the ... A MultiPolygon is a MultiSurface object composed of Polygon ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-polygon.html
Polygon Examples On a region map, Polygon objects could represent forests, districts, and so on. Polygon Assertions The boundary of a Polygon consists of a set of LinearRing objects (that is, LineString objects that are both simple and closed) that ... A Polygon is a planar Surface representing a multisided ...
https://dev.mysql.com/doc/refman/5.7/en/gis-format-conversion-functions.html
For example: mysql> SET @mp = 'MULTIPOINT(1 1, 2 2, 3 3)'; mysql> SELECT ST_AsText(ST_GeomFromText(@mp)); +---------------------------------+ | ST_AsText(ST_GeomFromText(@mp)) | +---------------------------------+ | MULTIPOINT((1 1),(2 2),(3 3)) | ... MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB ...See Section 12.16.3, ...
https://dev.mysql.com/doc/refman/5.7/en/gis-geometrycollection-property-functions.html
mysql> SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; mysql> SELECT ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)); +-------------------------------------------------+ | ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)) | ...
https://dev.mysql.com/doc/refman/5.7/en/gis-mysql-specific-functions.html
MySQL provides a set of useful nonstandard functions for creating geometry values. For example, you can insert the geometry return value from Point() directly into a POINT column: INSERT INTO t1 (pt_col) VALUES(Point(1,2)); GeometryCollection(g [, ...The functions described in this section are MySQL extensions to the OpenGIS ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
Index hints give the optimizer information about how to choose indexes during query processing. (For the general syntax for specifying tables in a SELECT statement, see Section 13.2.9.2, “JOIN Clause”.) The syntax for referring to an individual ...Index hints, described here, differ from optimizer hints, described in Section 8.9.3, “Optimizer ...
https://dev.mysql.com/doc/refman/5.7/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html
This function is typically used to produce a valid JSON string literal for inclusion within a JSON document. JSON_ARRAYAGG() returns a result set as a single JSON array, and JSON_OBJECTAGG() returns a result set as a single JSON object. The ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-file-plugin.html
Warning For encryption key management, the keyring_file plugin is not intended as a regulatory compliance solution. To install keyring_file, use the general instructions found in Section 6.4.4.1, “Keyring Plugin Installation”, together with the ... The keyring_file keyring plugin stores keyring data in a file local to the server ...