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 object p as a double-precision number.

  mysql> SELECT X(POINT(56.7, 53.34));
  +-----------------------+
  | X(POINT(56.7, 53.34)) |
  +-----------------------+
  | 56.7 |
  +-----------------------+
  

• Y(p)

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

Retornar