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/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. If srid refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. Feature and FeatureCollection objects are not supported, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-spatial-reference-systems-table.html
The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
If any SRID argument refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... As of MySQL 8.0.12, ASC and DESC are not permitted for SPATIAL indexes. (USING BTREE is supported as ...This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions.html
The functions described in this section take two geometries as arguments and return a qualitative or quantitative relation between them. MySQL implements two sets of functions using function names defined by the OpenGIS specification. One set tests ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
spatial_type As of MySQL 8.0.24, CAST() and CONVERT() support casting geometry values from one spatial type to another, for certain combinations of spatial types. Cast Operations on Spatial Types As of MySQL 8.0.24, CAST() and CONVERT() support ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
As of MySQL 8.0.3, spatial data types permit an SRID attribute, to explicitly indicate the spatial reference system (SRS) for values stored in the column. A spatial column with an explicit SRID attribute is SRID-restricted: The column takes only ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
Spatial indexes are not supported (although spatial columns can be used). What data types are supported by NDB Cluster? NDB Cluster supports all of the usual MySQL data types, including those associated with MySQL's spatial extensions; however, the ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...