Geometry Property Functions mysql>  SET @ls = ST_GeomFromText(’LineString(1 1,2 2,3 3)’); mysql>  SELECT ST_Length(@ls); mysql>  SET @mls = ST_GeomFromText(’MultiLineString((1 1,2 2,3 3),(4 4,5 5))’); mysql>  SELECT ST_Length(@mls); mysql>  SET @ls = ST_GeomFromText(’LineString(1 1,2 2,3 3)’, 4326); mysql>  SELECT ST_Length(@ls); mysql>  SELECT ST_Length(@ls, ’metre’); mysql>  SELECT ST_Length(@ls, ’foot’); +--------------------+ | ST_Length(@ls) | +--------------------+ | 2.8284271247461903 | +--------------------+ +-------------------+ | ST_Length(@mls) | +-------------------+ | 4.242640687119286 | +-------------------+ +-------------------+ | ST_Length(@ls) | +-------------------+ | 313701.9623204328 | +-------------------+ +-------------------------+ | ST_Length(@ls, ’metre’) | +-------------------------+ | 313701.9623204328 | +-------------------------+ +------------------------+ | ST_Length(@ls, ’foot’) | +------------------------+ | 1029205.9131247795 | +------------------------+ +------------------------------------+ | ST_NumPoints(ST_GeomFromText(@ls)) | +------------------------------------+ | 3 | +------------------------------------+ mysql>  SET @ls = ’LineString(1 1,2 2,3 3)’; mysql>  SELECT ST_NumPoints(ST_GeomFromText(@ls)); mysql>  SET @ls = ’LineString(1 1,2 2,3 3)’; mysql>  SELECT ST_AsText(ST_PointN(ST_GeomFromText(@ls),2)); +----------------------------------------------+ | ST_AsText(ST_PointN(ST_GeomFromText(@ls),2)) | +----------------------------------------------+ | POINT(2 2) | +----------------------------------------------+ Returns the number of  Point  objects in the  LineString  value  ls . ST_NumPoints()  handles its arguments as described in the introduction to this section. Returns the  N -th  Point  in the  Linestring  value  ls . Points are numbered beginning with 1. ST_PointN()  handles its arguments as described in the introduction to this section. • ST_NumPoints( ls ) • ST_PointN( ls ,  N ) 2312