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, 1185🔥, 0💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...