(mysql.info) point-property-functions

Info Catalog

(mysql.info) general-geometry-property-functions

(mysql.info) geometry-property-functions

(mysql.info) linestring-property-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 |
           +----------------------+
 

Info Catalog

(mysql.info) general-geometry-property-functions

(mysql.info) geometry-property-functions

(mysql.info) linestring-property-functions