The ASTEXT function specifies the bounding box in WKT format : ASTEXT « Geometric « SQL / MySQL






  1. SQL / MySQL
  2. Geometric
  3. ASTEXT

The ASTEXT function specifies the bounding box in WKT format

    
mysql>
mysql> SET @mp = GEOMFROMTEXT('MULTIPOINT(1 1, 10 99, 0 5)');
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> SELECT GEOMETRYTYPE(@mp);
+-------------------+
| GEOMETRYTYPE(@mp) |
+-------------------+
| MULTIPOINT        |
+-------------------+
1 row in set (0.00 sec)








Related examples in the same category

1.Use ASTEXT with point value
2.Querying geometric data is with the asText function