SYS_GUID

Generate a UUID without hyphens. This Oracle-compatible function returns a globally unique identifier as a 32-character hexadecimal string.

SYS_GUID is available from MariaDB 10.6.1.

The SYS_GUID function was introduced to enhance Oracle compatibility. Similar functionality can be achieved with the UUID function.

Syntax

SYS_GUID()

Description

Returns a 16-byte globally unique identifier (GUID), similar to the UUID function, but without the - character.

Example

SELECT SYS_GUID();
+----------------------------------+
| SYS_GUID()                       |
+----------------------------------+
| 2C574E45BA2811EBB265F859713E4BE4 |
+----------------------------------+

See Also

• UUID

• UUID_SHORT

• UUID data type

_{This page is licensed: CC BY-SA / Gnu FDL}