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/gis-class-geometry.html
This value identifies the geometry's associated spatial reference system that describes the coordinate space in which the geometry object is defined. Its coordinates in its spatial reference system, represented as double-precision (8-byte) numbers.
https://dev.mysql.com/doc/refman/9.7/en/geometry-well-formedness-validity.html
Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically well-formed. Spatial computations may detect some cases of invalid geometries and raise an error, but they may also ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-physical-structure.html
With the exception of spatial indexes, InnoDB indexes are B-tree data structures. Spatial indexes use R-trees, which are specialized data structures for indexing multi-dimensional data. Index records are stored in the leaf pages of their B-tree or ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-operations.html
Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this section. Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table ...
https://dev.mysql.com/doc/refman/9.7/en/gis-linestring-property-functions.html
If any geometry argument is a syntactically well-formed geometry in an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. ST_IsClosed() handles its arguments as described in the introduction to this section, with this ...You ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-st-geometry-columns-table.html
The ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. This table is based on the SQL/MM (ISO/IEC 13249-3) standard, with extensions as noted. MySQL implements ST_GEOMETRY_COLUMNS as a view on the ...
https://dev.mysql.com/doc/refman/9.7/en/archive-storage-engine.html
It does support ORDER BY operations, BLOB columns, and spatial data types (see Section 13.4.1, “Spatial Data Types”). The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/9.7/en/descending-indexes.html
Explicitly specified ASC and DESC designators for HASH, FULLTEXT, and SPATIAL indexes results in an error. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order.
https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-geometrycollection.html
All the elements in a geometry collection must be in the same spatial reference system (that is, in the same coordinate system). Restrictions may be based on: Element type (for example, a MultiPoint may contain only Point elements) Dimension ... A ...