1Distance - intersecting lines 2:memory: #use in-memory database 3SELECT Distance(GeomFromText('LINESTRING(0 0, 10 0)'), GeomFromText('LINESTRING(0 0, 0 5)')) 41 # rows (not including the header row) 51 # columns 6Distance(GeomFromText('LINESTRING(0 0, 10 0)'), GeomFromText('LINESTRING(0 0, 0 5)')) 70.0 8 9