Search



Search Results
Displaying 11 to 20 of 30 total results
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement. It can do the following: Optimize the loading of data sorted by primary key. Use a second session to monitor bulk load progress: If the data is sorted, there is a single stage: ...
https://dev.mysql.com/doc/refman/8.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-11.html
(WL #10620) Connector/J now recognizes the data type GEOMCOLLECTION, which has been introduced in MySQL 8.0.11 as an alias and preferred name to the previously known GEOMETRYCOLLECTION data type. Version 8.0.11 is the first General Availability ...
https://dev.mysql.com/doc/mysqld-version-reference/en/built-in-functions.html
The following table shows all built-in functions and operators available in MySQL Server. Introduced: The version or versions in which the item was introduced. Deprecated: The version or versions in which the item was deprecated. Removed: The ...
https://dev.mysql.com/doc/refman/8.4/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 ...
Displaying 11 to 20 of 30 total results