Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 46.3Mb
PDF (A4) - 46.3Mb
PDF (RPM) - 41.7Mb
HTML Download (TGZ) - 10.6Mb
HTML Download (Zip) - 10.7Mb
HTML Download (RPM) - 9.2Mb
Man Pages (TGZ) - 224.0Kb
Man Pages (Zip) - 329.4Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  INFORMATION_SCHEMA Tables  /  The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table

25.29 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table

The ST_UNITS_OF_MEASURE table (available as of MySQL 8.0.14) provides information about acceptable units for the ST_Distance() function.

The ST_UNITS_OF_MEASURE table has these columns:

  • UNIT_NAME

    The name of the unit.

  • UNIT_TYPE

    The unit type (for example, LINEAR).

  • CONVERSION_FACTOR

    A conversion factor used for internal calculations.

  • DESCRIPTION

    A description of the unit.