ST_GeometryFromText,ST_GeomFromText

将 WKT（Well Known Text）转换为相应的内存几何图形。

语法

GEOMETRY ST_GeometryFromText(VARCHAR wkt)

示例

MySQL > SELECT ST_AsText(ST_GeometryFromText("LINESTRING (1 1, 2 2)"));
+---------------------------------------------------------+
| st_astext(st_geometryfromtext('LINESTRING (1 1, 2 2)')) |
+---------------------------------------------------------+
| LINESTRING (1 1, 2 2)                                   |
+---------------------------------------------------------+

关键词

ST_GEOMETRYFROMTEXT,ST_GEOMFROMTEXT,ST,GEOMETRYFROMTEXT,GEOMFROMTEXT