16.5.2.2 Point Functions

16.5.2.2. `Point` Functions

A Point consists of 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> SET @pt = 'Point(56.7 53.34)';
mysql> SELECT X(GeomFromText(@pt));
+----------------------+
| X(GeomFromText(@pt)) |
+----------------------+
|                 56.7 |
+----------------------+

Y(p)

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

mysql> SET @pt = 'Point(56.7 53.34)';
mysql> SELECT Y(GeomFromText(@pt));
+----------------------+
| Y(GeomFromText(@pt)) |
+----------------------+
|                53.34 |
+----------------------+

16.5.2.2. Point Functions

16.5.2.2. `Point` Functions