Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 26.9Mb
PDF (A4) - 26.9Mb
PDF (RPM) - 25.3Mb
HTML Download (TGZ) - 6.3Mb
HTML Download (Zip) - 6.3Mb
HTML Download (RPM) - 5.3Mb
Man Pages (TGZ) - 157.6Kb
Man Pages (Zip) - 260.9Kb
Info (Gzip) - 2.6Mb
Info (Zip) - 2.6Mb
Excerpts from this Manual

12.15.7.2 Point Property 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.

    mysql> SELECT Y(Point(56.7, 53.34));
    +-----------------------+
    | Y(Point(56.7, 53.34)) |
    +-----------------------+
    |                 53.34 |
    +-----------------------+

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.