Collections:
UUID_SHORT() - Short 64-Bit UUID Integer
How to generate a short 64-bit UUID (Universal Unique IDentifier) integer using the UUID_SHORT() function?
✍: FYIcenter.com
UUID_SHORT() is a MySQL built-in function that returns a short 64-bit UUID (Universal Unique IDentifier) integer. For example:
SELECT UUID_SHORT(), UUID_SHORT(); -- +--------------------+--------------------+ -- | UUID_SHORT() | UUID_SHORT() | -- +--------------------+--------------------+ -- | 100608899635216387 | 100608899635216388 | -- +--------------------+--------------------+ SELECT UUID_SHORT(), SLEEP(3), UUID_SHORT(); -- +--------------------+----------+--------------------+ -- | UUID_SHORT() | SLEEP(3) | UUID_SHORT() | -- +--------------------+----------+--------------------+ -- | 100608899635216389 | 0 | 100608899635216390 | -- +--------------------+----------+--------------------+
Reference information of the UUID_SHORT() function:
UUID_SHORT(): uuid Returns a 64-bit UUID integer based on system id and server startup time. Arguments, return value and availability: uuid: Return value. The generated UUID. Available since MySQL 5.7.
UUID_SHORT() function uses the following expression to generate the 64-bit UUID integer:
(server_id & 255) << 56 + (server_startup_time_in_seconds << 24) + incremented_variable++;
So the 64-bit UUID integer consists of 3 parts:
We can see these parts, if we convert the UUID integer into a Hexadecimal string:
SELECT HEX(UUID_SHORT()), HEX(UUID_SHORT()); -- +-------------------+-------------------+ -- | HEX(UUID_SHORT()) | HEX(UUID_SHORT()) | -- +-------------------+-------------------+ -- | 1656F42DC000008 | 1656F42DC000009 | -- +-------------------+-------------------+
⇒ UUID_TO_BIN() - Converting UUID to Binary
⇐ UUID() - Generating UUID String
2023-12-10, 214🔥, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...