makeline1
:memory: #use in-memory database
SELECT AsText(MakeLine(GeomFromText("POINT(0 0)"), GeomFromText("POINT(1 2)")));
1 # rows (not including the header row)
1 # columns
AsText(MakeLine(GeomFromText("POINT(0 0)"), GeomFromText("POINT(1 2)")))
LINESTRING(0 0, 1 2)