st mysql_mysql-ST_Area()用于纬度和经度

根据MariaDB文件,它不提供此功能：

In MariaDB,the SRID value is just an integer associated with the geometry value. All calculations are done assuming Euclidean (planar) geometry.

但是,在Mysql 8.0.13中提供了此功能,您可以使用ST_Area()计算多边形面积：

Incompatible Change: Previously,ST_Area() supported only geometry arguments having a Cartesian spatial reference system (SRS) and produced an error when invoked with geometry arguments that specified a geographic SRS. ST_Area() now supports geometry arguments having a geographic SRS and returns the geodetic area in square meters.

因此,如果您将数据库更改为MYSQL> 8.0.13您可以使用以下查询计算多边形面积：

SELECT ST_Area(ST_PolyFromText('POLYGON((50.4668 -6.90665,50.4668 -6.90665))',4326));