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. 

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. 

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. 

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) | +---------------------------------+ 

This function was added in MySQL 8.0.12. 

• ST_Longitude( p  [, new_longitude_val ]) 

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. 

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. 

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. 

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) | +----------------------------------+ 

This function was added in MySQL 8.0.12. 

