Movatterモバイル変換

AsBinary(g),AsWKB(g)

ST_AsBinary(),ST_AsWKB(),AsBinary(), andAsWKB() are synonyms. For more information, see the description ofST_AsBinary().

AsBinary() andAsWKB() are deprecated; expect them to be removed in a future MySQL release. UseST_AsBinary() andST_AsWKB() instead.

AsText(g),AsWKT(g)

ST_AsText(),ST_AsWKT(),AsText(), andAsWKT() are synonyms. For more information, see the description ofST_AsText().

AsText() andAsWKT() are deprecated; expect them to be removed in a future MySQL release. UseST_AsText() andST_AsWKT() instead.

ST_AsBinary(g),ST_AsWKB(g)

Converts a value in internal geometry format to its WKB representation and returns the binary result.

If the argument isNULL, the return value isNULL. If the argument is not a syntactically well-formed geometry, anER_GIS_INVALID_DATA error occurs.

SELECT ST_AsBinary(g) FROM geom;

ST_AsBinary(),ST_AsWKB(),AsBinary(), andAsWKB() are synonyms.

ST_AsText(g),ST_AsWKT(g)

Converts a value in internal geometry format to its WKT representation and returns the string result.

If the argument isNULL, the return value isNULL. If the argument is not a syntactically well-formed geometry, anER_GIS_INVALID_DATA error occurs.

mysql> SET @g = 'LineString(1 1,2 2,3 3)';mysql> SELECT ST_AsText(ST_GeomFromText(@g));+--------------------------------+| ST_AsText(ST_GeomFromText(@g)) |+--------------------------------+| LINESTRING(1 1,2 2,3 3)        |+--------------------------------+

ST_AsText(),ST_AsWKT(),AsText(), andAsWKT() are synonyms.

Output forMultiPoint values includes parentheses around each point. For example:

mysql> SET @mp = 'MULTIPOINT(1 1, 2 2, 3 3)';mysql> SELECT ST_AsText(ST_GeomFromText(@mp));+---------------------------------+| ST_AsText(ST_GeomFromText(@mp)) |+---------------------------------+| MULTIPOINT((1 1),(2 2),(3 3))   |+---------------------------------+