Syntax
------ 
ST_LineFromText(wkt[,srid])
ST_LineStringFromText(wkt[,srid])
LineFromText(wkt[,srid])
LineStringFromText(wkt[,srid])
 
Description
----------- 
Constructs a LINESTRING value using its WKT representation
and SRID.
 
ST_LineFromText(), ST_LineStringFromText(),
ST_LineFromText() and ST_LineStringFromText() are all
synonyms.
 
Examples
-------- 
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)))));
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/st_linefromtext/