1linesubstring - basic 2:memory: #use in-memory database 3SELECT AsText(Line_Substring(GeomFromText('LINESTRINGZ(0 0 10, 10 0 10)'), 0, 0.4)) 41 # rows (not including the header row) 51 # columns 6AsText(Line_Substring(GeomFromText('LINESTRINGZ(0 0 10, 10 0 10)'), 0, 0.4)) 7LINESTRING Z(0 0 10, 4 0 10) 8 9