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, 1474🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...