11.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:

  mysql> CREATE TABLE geom (g GEOMETRY);
  Query OK, 0 rows affected (0.02 sec)
  

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

  mysql> ALTER TABLE geom ADD pt POINT;
  Query OK, 0 rows affected (0.00 sec)
  Records: 0  Duplicates: 0  Warnings: 0
  mysql> ALTER TABLE geom DROP pt;
  Query OK, 0 rows affected (0.00 sec)
  Records: 0  Duplicates: 0  Warnings: 0
  

User Comments

Add your own comment.