(mysql.info.gz) Point property functions

Info Catalog

(mysql.info.gz) General geometry property functions

(mysql.info.gz) Geometry property functions

(mysql.info.gz) Linestring property functions

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

Info Catalog

(mysql.info.gz) General geometry property functions

(mysql.info.gz) Geometry property functions

(mysql.info.gz) Linestring property functions