top of page
MySQL:
SPATIAL COLUMNS
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);
bottom of page