UUID_SHORT()

MySQL 8.4

Returns a “short” universal identifier as a 64-bit unsigned integer. Values returned by UUID_SHORT() differ from the string-format 128-bit identifiers returned by the UUID() function and have different uniqueness properties. The value of UUID_SHORT() is guaranteed to be unique if the following conditions hold:

Syntax

MYSQL

(server_id & 255) << 56
+ (server_startup_time_in_seconds << 24)
+ incremented_variable++;

Examples

Example

The server_id value of the current server is between 0 and 255 and is unique among your set of source and replica servers

MYSQL

(server_id & 255) << 56
+ (server_startup_time_in_seconds << 24)
+ incremented_variable++;

Example 2

You do not set back the system time for your server host between mysqld restarts

MYSQL

SELECT UUID_SHORT();
92395783831158784