Additional languages
« 16.4.2.3 Creating Geometry Values Using MySQL-Specific Functions
16.4.4 Populating Spatial Columns »
Section Navigation      [Toggle]

16.4.3. Creating Spatial Columns

MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Currently, spatial columns are supported only for MyISAM tables.

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

    CREATE TABLE geom (g GEOMETRY);

  • Use the ALTER 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;