Топ-100
top of page
CerebroSQL

ST_GEOMETRYTYPE

База данных: MySQL

68747470733a2f2f7374796c65732e7265646469746d656469612e636f6d2f74355f32716d366b2f7374796c65

Topic

ST_GeometryType(g)

Returns a binary string indicating the name of the geometry type of
which the geometry instance g is a member. The name corresponds to one
of the instantiable Geometry subclasses.

ST_GeometryType() handles its arguments as described in the
introduction to this section.

URL: https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html

Example

mysql> SELECT ST_GeometryType(ST_GeomFromText('POINT(1 1)'));
+------------------------------------------------+
| ST_GeometryType(ST_GeomFromText('POINT(1 1)')) |
+------------------------------------------------+
| POINT |
+------------------------------------------------+

bottom of page