Топ-100
 
CerebroSQL

SPATIAL COLUMNS

База данных: MySQL

68747470733a2f2f7374796c65732e7265646469746d656469612e636f6d2f74355f32716d366b2f7374796c65

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.

Example

CREATE TABLE geom (g GEOMETRY);