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, 2106🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
What Are the Differences between BINARY and VARBINARY in MySQL? Both BINARY and VARBINARY are both b...