SYS_GUID()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
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
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.