1ShortestLine - line and point 2:memory: #use in-memory database 3SELECT AsText(ShortestLine(GeomFromText('LINESTRING(0 0, 10 0)'), GeomFromText('POINT(10 2)'))) 41 # rows (not including the header row) 51 # columns 6AsText(ShortestLine(GeomFromText('LINESTRING(0 0, 10 0)'), GeomFromText('POINT(10 2)'))) 7LINESTRING(10 0, 10 2) 8 9