11.5.2.2 Point Property Analysis Functions

A Point consists of its X and Y coordinates, which may be obtained using the following functions:

X(p)

Returns the X-coordinate value for the point p as a double-precision number.

mysql> SELECT X(GeomFromText('Point(56.7 53.34)'));
+--------------------------------------+
| X(GeomFromText('Point(56.7 53.34)')) |
+--------------------------------------+
|                                 56.7 |
+--------------------------------------+

Y(p)

Returns the Y-coordinate value for the point p as a double-precision number.

mysql> SELECT Y(GeomFromText('Point(56.7 53.34)'));
+--------------------------------------+
| Y(GeomFromText('Point(56.7 53.34)')) |
+--------------------------------------+
|                                53.34 |
+--------------------------------------+

User Comments

Add your own comment.