MySQL Manual
11 Spatial Extensions in MySQL
- 11.1 Introduction
- 11.2 The OpenGIS Geometry Model
- 11.3 Supported Spatial Data Formats
- 11.4 Creating a Spatially Enabled MySQL Database
- 11.5 Analysing Spatial Information
- 11.6 Optimising Spatial Analysis
- 11.7 MySQL Conformance And Compatibility
11.4 Creating a Spatially Enabled MySQL Database
This section describes the datatypes you can use for representing spatial data in MySQL, and the functions available for creating and retrieving spatial values.
Subsections
- 11.4.1 MySQL Spatial Datatypes
- 11.4.2 Creating Spatial Values
- 11.4.2.1 Creating Geometry Values Using WKT Functions
- 11.4.2.2 Creating Geometry Values Using WKB Functions
- 11.4.2.3 Creating Geometry Values Using MySQL-Specific Functions
- 11.4.3 Creating Spatial Columns
- 11.4.4 Populating Spatial Columns
- 11.4.5 Fetching Spatial Data
