1Closest Point - two pointZMs 2:memory: #use in-memory database 3SELECT AsText(ClosestPoint(GeomFromText('POINTZM(1 2 0 4)'), GeomFromText('POINTZM(4 6 1 5)'))); 41 # rows (not including the header row) 51 # columns 6AsText(ClosestPoint(GeomFromText('POINTZM(1 2 0 4)'), GeomFromText('POINTZM(4 6 1 5)'))) 7POINT ZM(1 2 0 0) 8 9