SYS_GUID()

Overview

In 10.6 ES:

Returns a 32-byte globally unique identifier.

In 10.5 ES, 10.4 ES:

Not present

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

USAGE

SYS_GUID()

DETAILS

  • SYS_GUID() returns a 32 byte globally unique identifier.

  • SYS_GUID() differs from UUID(), because the SYS_GUID() function does not include the '-' character in output, and it uses a different algorithm than UUID().

EXAMPLES

Simple Example

Each time SYS_GUID() is invoked, it returns a different value, even when invoked multiple times within the same expression. The change in value often occurs within the first 8 bytes:

SELECT SYS_GUID();
+----------------------------------+
| SYS_GUID()                       |
+----------------------------------+
| 48B6E39EEE5511EB8805BADD8ED179A2 |
+----------------------------------+
SELECT SYS_GUID();
+----------------------------------+
| SYS_GUID()                       |
+----------------------------------+
| 48B94E91EE5511EB8805BADD8ED179A2 |
+----------------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Added in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Not present.

10.4 Enterprise

  • Not present.

EXTERNAL REFERENCES