mysql>  SET @pt = ST_GeomFromText(’POINT(45 90)’, 4326); mysql>  SELECT ST_Latitude(@pt); +------------------+ | ST_Latitude(@pt) | +------------------+ | 45 | +------------------+ mysql>  SELECT ST_AsText(ST_Latitude(@pt, 10)); +---------------------------------+ | ST_AsText(ST_Latitude(@pt, 10)) | +---------------------------------+ | POINT(10 90) | +---------------------------------+ mysql>  SET @pt = ST_GeomFromText(’POINT(45 90)’, 4326); mysql>  SELECT ST_Longitude(@pt); +-------------------+ | ST_Longitude(@pt) | +-------------------+ | 90 | +-------------------+ mysql>  SELECT ST_AsText(ST_Longitude(@pt, 10)); +----------------------------------+ | ST_AsText(ST_Longitude(@pt, 10)) | +----------------------------------+ | POINT(45 10) | +----------------------------------+ 2307 This function was added in MySQL 8.0.12. ST_Longitude()  handles its arguments as described in the introduction to this section, with the addition that if the  Point  object is valid but does not have a geographic SRS, an ER_SRS_NOT_GEOGRAPHIC  error occurs. With the optional second argument representing a valid longitude value,  ST_Longitude()  returns a Point  object like the first argument with its longitude equal to the second argument. With a single argument representing a valid  Point  object  p  that has a geographic spatial reference system (SRS),  ST_Longitude()  returns the longitude value of  p  as a double-precision number. This function was added in MySQL 8.0.12. • ST_Longitude( p  [,  new_longitude_val ]) ST_Latitude()  handles its arguments as described in the introduction to this section, with the addition that if the  Point  object is valid but does not have a geographic SRS, an  ER_SRS_NOT_GEOGRAPHIC error occurs. With the optional second argument representing a valid latitude value,  ST_Latitude()  returns a Point  object like the first argument with its latitude equal to the second argument. With a single argument representing a valid  Point  object  p  that has a geographic spatial reference system (SRS),  ST_Latitude()  returns the latitude value of  p  as a double-precision number. Geometry Property Functions