1
2
3
4
5
6
7
|
geomfromtext41
:memory: #use in-memory database
SELECT AsText(GeomFromText('GEOMETRYCOLLECTIONM(GEOMETRYCOLLECTIONM(POINTM(0 0 9), LINESTRINGM(1 1 9, 2 2 9)), GEOMETRYCOLLECTIONM(POINTM(3 3 9), LINESTRINGM(4 4 9, 5 5 9)))'));
1 # rows (not including the header row)
1 # columns
AsText(GeomFromText('GEOMETRYCOLLECTIONM(GEOMETRYCOLLECTIONM(POINTM(0 0 9), LINESTRINGM(1 1 9, 2 2 9)), GEOMETRYCOLLECTIONM(POINTM(3 3 9), LINESTRINGM(4 4 9, 5 5 9)))'));
GEOMETRYCOLLECTION M(POINT M(0 0 9), POINT M(3 3 9), LINESTRING M(1 1 9, 2 2 9), LINESTRING M(4 4 9, 5 5 9))
|
