SYS_GUID()
This page is part of MariaDB's SkySQL Documentation.
The parent of this page is: Functions
Topics on this page:
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 theSYS_GUID()function does not include the '-' character in output, and it uses a different algorithm thanUUID().
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 |
|
10.5 Enterprise |
|
10.4 Enterprise |
|
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.