Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  / ...  / Data Types  / Spatial Data Types  /  Creating Spatial Columns

13.4.6 Creating Spatial Columns

MySQL provides a standard way of creating spatial columns for geometry types, for example, withCREATE TABLE orALTER TABLE. Spatial columns are supported forMyISAM,InnoDB,NDB, andARCHIVE tables. See also the notes about spatial indexes underSection 13.4.10, “Creating 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, seeSection 13.4.1, “Spatial Data Types”.

  • Use theCREATE TABLE statement to create a table with a spatial column:

    CREATE TABLE geom (g GEOMETRY);

  • Use theALTER TABLE statement to add or drop a spatial column to or from an existing table:

    ALTER TABLE geom ADD pt POINT;ALTER TABLE geom DROP pt;