How to convert a binary string to a UUID (Universal Unique IDentifier) string using the BIN_TO_UUID() function?

BIN_TO_UUID(bin, swap) is a MySQL built-in function that converts a given binary value of 128 bits into a UUID (Universal Unique IDentifier) string. The swap flag allows you to swap the first part with the second and the third parts in the UUID string. For example:

SELECT BIN_TO_UUID(x'12345678901234567890123456789012');
  -- +--------------------------------------------------+
  -- | BIN_TO_UUID(x'12345678901234567890123456789012') |
  -- +--------------------------------------------------+
  -- | 12345678-9012-3456-7890-123456789012             |
  -- +--------------------------------------------------+

SELECT BIN_TO_UUID(x'12345678901234567890123456789012', 1);
  -- +-----------------------------------------------------+
  -- | BIN_TO_UUID(x'12345678901234567890123456789012', 1) |
  -- +-----------------------------------------------------+
  -- | 90123456-5678-1234-7890-123456789012                |
  -- +-----------------------------------------------------+

Reference information of the BIN_TO_UUID() function:

BIN_TO_UUID(bin, swap): uuid
  Returns the UUID string converted from the given 128-bit binary string
  with the option to swap the first part with the second and the third parts.

Arguments, return value and availability:
  bin: Required. The 128-bit binary string to be converted.
  swap: Optional. The default is 0. if 1 is specified, the he first part
    of the UUID is swapped with the second and the third parts.
  uuid: Return value. The converted UUID string.
  Available since MySQL 8.0.

⇒ IS_UUID() - Validating UUID String Format

⇐ MySQL Functions on UUID Values

⇑ MySQL Functions on UUID Values

⇑⇑ MySQL Function References