Топ-100
 

SPATIAL COLUMNS

RDBMS Type: MySQL
Topic

MySQL provides a standard way of creating spatial columns for geometry
types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns
are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the
notes about spatial indexes under [HELP SPATIAL indexes].

Columns with a spatial data type can have an SRID attribute, to
explicitly indicate the spatial reference system (SRS) for values
stored in the column. For implications of an SRID-restricted column,
see https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html.

URL: https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html

Example

CREATE TABLE geom (g GEOMETRY);