ST_LineFromText(wkt[,srid]) ST_LineStringFromText(wkt[,srid]) LineFromText(wkt[,srid]) LineStringFromText(wkt[,srid])
Constructs a LINESTRING value using its WKT representation and SRID.
ST_LineFromText()
, ST_LineStringFromText()
, ST_LineFromText()
and ST_LineStringFromText()
are all synonyms.
CREATE TABLE gis_line (g LINESTRING); SHOW FIELDS FROM gis_line; INSERT INTO gis_line VALUES (LineFromText('LINESTRING(0 0,0 10,10 0)')), (LineStringFromText('LINESTRING(10 10,20 10,20 20,10 20,10 10)')), (LineStringFromWKB(AsWKB(LineString(Point(10, 10), Point(40, 10)))));
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/linefromtext/