MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 18 of 18 total results

« Previous
1
2
Next »

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 ...

14.16.5 MySQL-Specific Functions That Create Geometry Values

https://dev.mysql.com/doc/refman/8.0/en/gis-mysql-specific-functions.html

MultiLineString(ls [, ls] ...) Constructs a MultiLineString value using LineString or WKB LineString arguments. MySQL provides a set of useful nonstandard functions for creating geometry values. The functions described in this section are MySQL ...

13.4.2.2 Geometry Class

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 ...

28.3.35 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table

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 ...

11.3 Keywords and Reserved Words

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 ...

14.16.12 Spatial Aggregate Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html

If all arguments are LineString values, the result is a MultiLineString value. MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate ...

14.16.4 Functions That Create Geometry Values from WKB Values

https://dev.mysql.com/doc/refman/8.0/en/gis-wkb-functions.html

ST_MLineFromWKB(wkb [, srid [, options]]), ST_MultiLineStringFromWKB(wkb [, srid [, options]]) Constructs a MultiLineString value using its WKB representation and SRID. These functions take as arguments a BLOB containing a Well-Known Binary (WKB) ...

14.16.7.4 Polygon and MultiPolygon Property Functions

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 ...