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/populating-spatial-columns.html

After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...

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.4 Functions That Create Geometry Values from WKB Values

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

These functions are available for creating geometries from WKB values: ST_GeomCollFromWKB(wkb [, srid [, options]]), ST_GeometryCollectionFromWKB(wkb [, srid [, options]]) Constructs a GeometryCollection value using its WKB representation and SRID.

13.4.4 Geometry Well-Formedness and Validity

https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html

For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...

14.16.2 Argument Handling by Spatial Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-function-argument-handling.html

Empty geometry collection handling is as follows: An empty WKT input geometry collection may be specified as 'GEOMETRYCOLLECTION()'. Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific ...

14.16.1 Spatial Function Reference

https://dev.mysql.com/doc/refman/8.0/en/spatial-function-reference.html

The following table lists each spatial function and provides a short description of each one.

14.1 Built-In Function and Operator Reference

https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html

The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...