1Closest Point - Point and lineZ 2:memory: #use in-memory database 3SELECT AsText(ClosestPoint(GeomFromText('LINESTRINGZ(0 0 0, 0 10 5)'), MakePoint(4, 6))); 41 # rows (not including the header row) 51 # columns 6AsText(ClosestPoint(GeomFromText('LINESTRINGZ(0 0 0, 0 10 5)'), MakePoint(4, 6))) 7POINT Z(0 6 3) 8 9