MySQL 8.4 Release Notes
ST_GEOMETRY_COLUMNS 表提供有关存储空间数据的表列的信息。该表基于 SQL/MM（ISO/IEC 13249-3）标准，并有如注释中所述的扩展。MySQL 将 ST_GEOMETRY_COLUMNS 实现为 INFORMATION_SCHEMA COLUMNS 表上的视图。The ST_GEOMETRY_COLUMNS table
provides information about table columns that store spatial data.
This table is based on the SQL/MM (ISO/IEC 13249-3) standard, with
extensions as noted. MySQL implements
ST_GEOMETRY_COLUMNS as a view on the
INFORMATION_SCHEMA
COLUMNS table.
ST_GEOMETRY_COLUMNS 表有以下列：The ST_GEOMETRY_COLUMNS table has
these columns:
TABLE_CATALOG包含该列的表所属的目录名称。此值始终为
def。The name of the catalog to which the table containing the column belongs. This value is alwaysdef.TABLE_SCHEMA包含该列的表所属的模式（数据库）名称。The name of the schema (database) to which the table containing the column belongs.
TABLE_NAMETABLE_NAME包含该列的表名称。The name of the table containing the column.
COLUMN_NAMECOLUMN_NAME列名称。The name of the column.
SRS_NAME空间参考系统（SRS）名称。The spatial reference system (SRS) name.
SRS_ID空间参考系统 ID（SRID）。The spatial reference system ID (SRID).
GEOMETRY_TYPE_NAME列的数据类型。允许的值有：
geometry、point、linestring、polygon、multipoint、multilinestring、multipolygon、geometrycollection。此列是 MySQL 对标准的扩展。The column data type. Permitted values are:geometry,point,linestring,polygon,multipoint,multilinestring,multipolygon,geometrycollection. This column is a MySQL extension to the standard.