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