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
See ST_
EXAMPLES
SELECT AsText(ST_PolyFromText(
'POLYGON((15 40, 15 20, 25 20, 30 25, 30 35, 25 40, 15 40))'
)) AS Textify;
+------------------------------------------------------+
| Textify |
+------------------------------------------------------+
| POLYGON((15 40,15 20,25 20,30 25,30 35,25 40,15 40)) |
+------------------------------------------------------+
SET @multip = 'MULTIPOINT(1 1, 5 5, 10 10)';
SELECT AsText(ST_GeomFromText(@multip));
+----------------------------------+
| AsText(ST_GeomFromText(@multip)) |
+----------------------------------+
| MULTIPOINT(1 1,5 5,10 10) |
+----------------------------------+
SET @var = 'LINESTRING(0 0, 10 10, 20 20, 30 30)';
SELECT AsText(ST_GeomFromText(@var));
+-----------------------------------+
| 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.