SYS_GUID()

This page is part of MariaDB's SkySQL Documentation.

The parent of this page is: Functions

Topics on this page:

Overview
USAGE
DETAILS
EXAMPLES
- Simple Example
CHANGE HISTORY
EXTERNAL REFERENCES

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

Additional information on this topic may be found in the MariaDB Public Knowledge Base.

This page shows information specific to MariaDB SkySQL. Information for non-SkySQL use can be found on the SYS_GUID() page in the MariaDB Enterprise Documentation.