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/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... ASC and DESC are not supported for HASH indexes, multi-valued indexes or SPATIAL indexes. (USING BTREE ...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/9.7/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/9.7/en/cast-functions.html
spatial_type CAST() and CONVERT() support casting geometry values from one spatial type to another, for certain combinations of spatial types. Cast Operations on Spatial Types CAST() and CONVERT() support casting geometry values from one spatial ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... Spatial types are supported only for InnoDB and MyISAM tables, and indexed columns must be declared as NOT NULL. Columns using BLOB, TEXT, SET, ENUM, BIT, or spatial ...| [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/9.7/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 ...