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, 1308🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema in Oracle? For a us...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...