MySQL Manual
11 Spatial Extensions in MySQL
- 11.4 Creating a Spatially Enabled MySQL Database
- 11.4.5 Fetching Spatial Data
- 11.4.5.1 Fetching Spatial Data in Internal Format
- 11.4.5.2 Fetching Spatial Data in WKT Format
- 11.4.5.3 Fetching Spatial Data in WKB Format
11.4.5.1 Fetching Spatial Data in Internal Format
Fetching geometry values using internal format can be useful in table-to-table transfers:
CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom;
