MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
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().
ST_Y() and
Y() are synonyms. For more
information, see the description of
ST_Y().