St_Point

Description

Syntax:

POINT ST_Point(DOUBLE x, DOUBLE y)

This function returns the corresponding point based on the given X and Y coordinate values. The values are only meaningful in spherical sets, and X/Y respectively denote longitude/latitude. Please note that if you directly input select ST_Point(), it will get stuck.

Example

mysql> SELECT ST_AsText(ST_Point(24.7, 56.7));
+---------------------------------+
| st_astext(st_point(24.7, 56.7)) |
+---------------------------------+
| POINT (24.7 56.7)               |
+---------------------------------+

Keywords

ST_POINT,ST,POINT