Collections:
UUID() - Generating UUID String
How to generate a UUID (Universal Unique IDentifier) string using the UUID() function?
✍: FYIcenter.com
UUID() is a MySQL built-in function that
returns a UUID (Universal Unique IDentifier) string.
For example:
SELECT UUID(), UUID(); -- +--------------------------------------+--------------------------------------+ -- | UUID() | UUID() | -- +--------------------------------------+--------------------------------------+ -- | 447f9022-956d-11ee-b1eb-65d6038dbafa | 447f902c-956d-11ee-b1eb-65d6038dbafa | -- +--------------------------------------+--------------------------------------+ SELECT UUID(), SLEEP(3), UUID(); -- +--------------------------------------+----------+--------------------------------------+ -- | UUID() | SLEEP(3) | UUID() | -- +--------------------------------------+----------+--------------------------------------+ -- | cbd1deb6-956f-11ee-b1eb-65d6038dbafa | 0 | cd9c631a-956f-11ee-b1eb-65d6038dbafa | -- +--------------------------------------+----------+--------------------------------------+
Reference information of the UUID() function:
UUID(): uuid Returns a UUID string using the current time and host information. Arguments, return value and availability: uuid: Return value. The generated UUID. Available since MySQL 5.7.
UUID() function returns a UUID value that that conforms to UUID version 1 as described in RFC 4122. The value is a 128-bit number represented in 32 hexadecimal digits divided into 5 parts as in "aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee" format, where:
⇒ UUID_SHORT() - Short 64-Bit UUID Integer
⇐ IS_UUID() - Validating UUID String Format
2023-12-08, 1690🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...