MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6
A Point
consists of X and Y coordinates,
which may be obtained using the following functions:
Returns the X-coordinate value for the
Point
object p
as a double-precision number.
mysql> SELECT ST_X(Point(56.7, 53.34));
+--------------------------+
| ST_X(Point(56.7, 53.34)) |
+--------------------------+
| 56.7 |
+--------------------------+
Returns the Y-coordinate value for the
Point
object p
as a double-precision number.
mysql> SELECT ST_Y(Point(56.7, 53.34));
+--------------------------+
| ST_Y(Point(56.7, 53.34)) |
+--------------------------+
| 53.34 |
+--------------------------+
ST_X()
and
X()
are synonyms. For more
information, see the description of
ST_X()
.
X()
is deprecated; expect it
to be removed in a future MySQL release. Use
ST_X()
instead.
ST_Y()
and
Y()
are synonyms. For more
information, see the description of
ST_Y()
.
Y()
is deprecated; expect it
to be removed in a future MySQL release. Use
ST_Y()
instead.