(mysql.info.gz) MySQL spatial datatypes

Info Catalog

(mysql.info.gz) Creating a spatially enabled MySQL database

(mysql.info.gz) Creating a spatially enabled MySQL database

(mysql.info.gz) Creating spatial values

 
 18.4.1 MySQL Spatial Data Types
 -------------------------------
 
 MySQL has data types that correspond to OpenGIS classes.  Some of these
 types hold single geometry values:
 
    * `GEOMETRY'
 
    * `POINT'
 
    * `LINESTRING'
 
    * `POLYGON'
 
 `GEOMETRY' can store geometry values of any type.  The other
 single-value types, `POINT' and `LINESTRING' and `POLYGON', restrict
 their values to a particular geometry type.
 
 The other data types hold collections of values:
 
    * `MULTIPOINT'
 
    * `MULTILINESTRING'
 
    * `MULTIPOLYGON'
 
    * `GEOMETRYCOLLECTION'
 
 `GEOMETRYCOLLECTION' can store a collection of objects of any type. The
 other collection types, `MULTIPOINT' and `MULTILINESTRING' and
 `MULTIPOLYGON' and `GEOMETRYCOLLECTION', restrict collection members to
 those having a particular geometry type.
 

Info Catalog

(mysql.info.gz) Creating a spatially enabled MySQL database

(mysql.info.gz) Creating a spatially enabled MySQL database

(mysql.info.gz) Creating spatial values