ST_ASTEXT()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns the WKT representation of the given argument as a string result.
EXAMPLES
SET @var = 'MULTIPOINT(1 1, 5 5, 10 10)';
SELECT ST_AsText(ST_GeomFromText(@var));
+----------------------------------+
| ST_AsText(ST_GeomFromText(@var)) |
+----------------------------------+
| MULTIPOINT(1 1,5 5,10 10) |
+----------------------------------+
SET @var = 'LINESTRING(0 0, 10 10, 20 20, 30 30)';
SELECT ST_AsText(ST_GeomFromText(@var));
+-----------------------------------+
| ST_AsText(ST_GeomFromText(@var)) |
+-----------------------------------+
| LINESTRING(0 0,10 10,20 20,30 30) |
+-----------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.