PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/gis-format-conversion-functions.html
If any geometry argument is in an undefined spatial reference system, the axes are output in the order they appear in the geometry and an ER_WARN_SRS_NOT_FOUND_AXIS_ORDER warning occurs. By default, geographic coordinates (latitude, longitude) are ... MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping the order of X and Y ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/en/alter-table.html
| ADD {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... Changing the definition of a spatial column to remove the SRID attribute. ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
have_geometry YES if the server supports spatial data types, NO if not. The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the command line or in an option ...