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/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial Indexes”). The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to ...
https://dev.mysql.com/doc/refman/9.7/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-curve.html
A Curve is a one-dimensional geometry, usually represented by a sequence of points. Particular subclasses of Curve define the type of interpolation between points. A Curve is simple if it does not pass through the same point twice, with the ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-multicurve.html
A MultiCurve is a geometry collection composed of Curve elements. A MultiCurve is simple if and only if all of its elements are simple; the only intersections between any two elements occur at points that are on the boundaries of both elements. A ...
https://dev.mysql.com/doc/refman/9.7/en/gis-class-multipoint.html
A MultiPoint is a geometry collection composed of Point elements. MultiPoint Examples On a world map, a MultiPoint could represent a chain of small islands. On a city map, a MultiPoint could represent the outlets for a ticket office. A MultiPoint ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-reference-systems.html
A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial reference systems: A projected SRS is a projection of a globe onto a flat surface; that is, a flat map.
https://dev.mysql.com/doc/refman/9.7/en/gis-class-point.html
A Point is a geometry that represents a single location in coordinate space. Point Examples Imagine a large-scale map of the world with many cities. On a city map, a Point object could represent a bus stop.
https://dev.mysql.com/doc/refman/9.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". The functions in this section ...
https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions-and-modifiers.html
They are often used with a GROUP BY clause to group values into subsets. For information about aggregate functions that operate on geometry values, see Section 14.16.12, “Spatial Aggregate Functions”.
https://dev.mysql.com/doc/refman/9.7/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...