18.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 |
+----------------------+
