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/creating-spatial-indexes.html
To drop spatial indexes, use ALTER TABLE or DROP INDEX: With ALTER TABLE: ALTER TABLE geom DROP INDEX g; With DROP INDEX: DROP INDEX g ON geom; Example: Suppose that a table geom contains more than 32,000 geometries, which are stored in the column g ... For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/9.7/en/fetching-spatial-data.html
Geometry values stored in a table can be fetched in internal format. Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-geometrycollection.html
A GeomCollection is a geometry that is a collection of zero or more geometries of any class. GeomCollection and GeometryCollection are synonymous, with GeomCollection the preferred type name. All the elements in a geometry collection must be in the ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-surface.html
Polyhedral surfaces are formed by “stitching” together simple surfaces along their boundaries, polyhedral surfaces in three-dimensional space may not be planar as a whole. The OpenGIS specification defines a simple Surface as a geometry that ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-spatial-analysis.html
For most geometries, the MBR is a minimum rectangle that surrounds the geometries. For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-polygon.html
A Polygon is a planar Surface representing a multisided geometry. It is defined by a single exterior boundary and zero or more interior boundaries, where each interior boundary defines a hole in the Polygon. Polygon Examples On a region map, ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-syntax.html
Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary tables. Trying either to create a temporary table that uses the NDB storage engine or to alter an ...
https://dev.mysql.com/doc/refman/9.7/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes about spatial indexes under ...
https://dev.mysql.com/doc/refman/9.7/en/json.html
The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...