MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 21 to 29 of 29 total results

« Previous
1
2
3
Next »

15.1.17 CREATE JSON DUALITY VIEW Statement

https://dev.mysql.com/doc/refman/9.7/en/create-json-duality-view.html

Columns of types JSON, VECTOR, and GEOMETRY (including all derivatives such as POINT, LINESTRING, and POLYGON) are not supported, nor are generated columns. CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE}] [DEFINER = user] [SQL SECURITY ...

13.4.2.2 Geometry Class

https://dev.mysql.com/doc/refman/9.7/en/gis-class-geometry.html

The dimensions of MultiPoint, MultiLineString, and MultiPolygon objects are the same as the dimensions of the elements they consist of. It is a noninstantiable class but has a number of properties, described in the following list, that are common to ...

13.4.2.6 Surface Class

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

14.16.12 Spatial Aggregate Functions

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

If all arguments are Polygon values, the result is a MultiPolygon 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 Function ...

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/9.7/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 ...

28.3.41 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table

https://dev.mysql.com/doc/refman/9.7/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 ...

MySQL Glossary

https://dev.mysql.com/doc/refman/9.7/en/glossary.html

R R-tree A tree data structure used for spatial indexing of multi-dimensional data such as geographical coordinates, rectangles or polygons. These terms are commonly used in information about the MySQL database server. Files with this extension are ...

14.16.3 Functions That Create Geometry Values from WKT Values

https://dev.mysql.com/doc/refman/9.7/en/gis-wkt-functions.html

ST_MPolyFromText(wkt [, srid [, options]]), ST_MultiPolygonFromText(wkt [, srid [, options]]) Constructs a MultiPolygon value using its WKT representation and SRID. ST_PolyFromText(wkt [, srid [, options]]), ST_PolygonFromText(wkt [, srid [, ...

14.16.4 Functions That Create Geometry Values from WKB Values

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

ST_MPolyFromWKB(wkb [, srid [, options]]), ST_MultiPolygonFromWKB(wkb [, srid [, options]]) Constructs a MultiPolygon value using its WKB representation and SRID. ST_PolyFromWKB(wkb [, srid [, options]]), ST_PolygonFromWKB(wkb [, srid [, options]]) ... These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier ...