ST_GeometryFromText,ST GeomFromText

Description

Syntax

GEOMETRY ST_GeometryFromText (VARCHAR wkt)

Converting a WKT (Well Known Text) into a corresponding memory geometry

example

  1. mysql> SELECT ST_AsText(ST_GeometryFromText("LINESTRING (1 1, 2 2)"));
  2. +---------------------------------------------------------+
  3. | st_astext(st_geometryfromtext('LINESTRING (1 1, 2 2)')) |
  4. +---------------------------------------------------------+
  5. | LINESTRING (1 1, 2 2)                                   |
  6. +---------------------------------------------------------+

keyword

ST_GEOMETRYFROMTEXT,ST_GEOMFROMTEXT,ST,GEOMETRYFROMTEXT,GEOMFROMTEXT