Syntax

ST_Y(p)
Y(p)

Description

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

ST_Y() and Y() are synonyms.

Examples

SET @pt = 'Point(56.7 53.34)';

SELECT Y(GeomFromText(@pt));
+----------------------+
| Y(GeomFromText(@pt)) |
+----------------------+
|                53.34 |
+----------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}

A synonym for ST_Y.

_{This page is licensed: CC BY-SA / Gnu FDL}

Syntax

Description

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

ST_X() and X() are synonyms.

Examples

_{This page is licensed: GPLv2, originally from}

A synonym for .

_{This page is licensed: CC BY-SA / Gnu FDL}