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