Copy SET @ls = 'LineString(1 1,2 2,3 3)' ;
SELECT AsText( EndPoint (GeomFromText(@ls)));
+ -------------------------------------+
| AsText( EndPoint (GeomFromText(@ls))) |
+ -------------------------------------+
| POINT ( 3 3 ) |
+ -------------------------------------+
CREATE TABLE gis_line (g LINESTRING);
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 )))));
Copy CREATE TABLE linestring_example (
g LINESTRING
);
Copy INSERT INTO linestring_example VALUES
(ST_LineFromText('LINESTRING(0 0, 1 1, 2 2)')),
(ST_LineStringFromText('LINESTRING(10 10, 20 10, 20 20, 10 20, 10 10)')),
(LineString(Point(10, 10), Point(40, 10)));
Copy SELECT ST_AsWKT(g) FROM linestring_example;
<</code>>
<<sql>>
+-------------------------------------------+
| ST_AsWKT(g) |
+-------------------------------------------+
| LINESTRING(0 0,1 1,2 2) |
| LINESTRING(10 10,20 10,20 20,10 20,10 10) |
| LINESTRING(10 10,40 10) |
+-------------------------------------------+