Search

Download this Manual
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


Displaying 11 to 20 of 20 total results
https://dev.mysql.com/doc/refman/8.0/en/gis-geometry-class-hierarchy.html
The geometry classes define a hierarchy as follows: Geometry (noninstantiable) Point (instantiable) Curve (noninstantiable) LineString (instantiable) Line LinearRing Surface (noninstantiable) Polygon (instantiable) GeometryCollection (instantiable) ...All classes have properties, and instantiable classes may also have assertions (rules that define valid class ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html
The other spatial data types hold collections of values: MULTIPOINT MULTILINESTRING MULTIPOLYGON GEOMETRYCOLLECTION GEOMETRYCOLLECTION can store a collection of objects of any type. The other collection types (MULTIPOINT, MULTILINESTRING, and ...
https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html
MultiPoint(pt [, pt2] ...) Constructs a MultiPoint value using Point or WKB Point arguments. MySQL provides a set of useful nonstandard functions for creating geometry values. The functions described in this section are MySQL extensions to the ...
https://dev.mysql.com/doc/refman/8.0/en/gis-format-conversion-functions.html
mysql> SET @g = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_GeomFromText(@g)); +--------------------------------+ | ST_AsText(ST_GeomFromText(@g)) | +--------------------------------+ | LINESTRING(1 1,2 2,3 3) | ... MySQL supports the ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometry.html
Geometry values of types (LineString, MultiPoint, MultiLineString) are either simple or nonsimple. The dimensions of MultiPoint, MultiLineString, and MultiPolygon objects are the same as the dimensions of the elements they consist of. It is a ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-geometry-columns-table.html
Permitted values are: geometry, point, linestring, polygon, multipoint, multilinestring, multipolygon, geometrycollection. The ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. This table is based on the ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkb-functions.html
ST_MPointFromWKB(wkb [, srid [, options]]), ST_MultiPointFromWKB(wkb [, srid [, options]]) Constructs a MultiPoint value using its WKB representation and SRID. These functions take as arguments a BLOB containing a Well-Known Binary (WKB) ...
https://dev.mysql.com/doc/refman/8.0/en/gis-polygon-property-functions.html
Such components are extracted and made into a single MultiPolygon, MultiLineString, or MultiPoint for centroid computation. Functions in this section return properties of Polygon or MultiPolygon values. Unless otherwise specified, functions in this ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometrycollection.html
Restrictions may be based on: Element type (for example, a MultiPoint may contain only Point elements) Dimension Constraints on the degree of spatial overlap between elements . A GeomCollection is a geometry that is a collection of zero or more ...
Displaying 11 to 20 of 20 total results