Collections:
UUID_TO_BIN() - Converting UUID to Binary
How to convert a UUID (Universal Unique IDentifier) string to binary a string using the UUID_TO_BIN() function?
✍: FYIcenter.com
UUID_TO_BIN(uuid, swap) is a MySQL built-in function that converts a UUID (Universal Unique IDentifier) string into a given binary value of 128 bits. The swap flag allows you to swap the first part with the second and the third parts in the UUID string. For example:
SELECT HEX(UUID_TO_BIN('12345678-9012-3456-7890-123456789012')); -- +----------------------------------------------------------+ -- | HEX(UUID_TO_BIN('12345678-9012-3456-7890-123456789012')) | -- +----------------------------------------------------------+ -- | 12345678901234567890123456789012 | -- +----------------------------------------------------------+ SELECT HEX(UUID_TO_BIN('12345678-9012-3456-7890-123456789012', 1)); -- +-------------------------------------------------------------+ -- | HEX(UUID_TO_BIN('12345678-9012-3456-7890-123456789012', 1)) | -- +-------------------------------------------------------------+ -- | 34569012123456787890123456789012 | -- +-------------------------------------------------------------+ SELECT HEX(UUID_TO_BIN(UUID())); -- +----------------------------------+ -- | HEX(UUID_TO_BIN(UUID())) | -- +----------------------------------+ -- | 55F0F080957C11EEB1EB65D6038DBAFA | -- +----------------------------------+
Reference information of the UUID_TO_BIN() function:
UUID_TO_BIN(uuid, swap): bin Returns the 128-bit binary string converted from the given UUID with the option to swap the first part with the second and the third parts. Arguments, return value and availability: uuid: Required. The UUID 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. bin: Return value. The converted converted 128-bit binary string. Available since MySQL 8.0.
⇒ MySQL Functions on System Information
⇐ UUID_SHORT() - Short 64-Bit UUID Integer
2023-12-11, 278🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...