©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
SQL functionMySQLMariaDB

The UUID_SHORT SQL Function in MySQL and MariaDB - Universal Unique Identifier - Short

UUID_SHORTSyntax:UUID_SHORT()
Return value:INTEGER
Function type:Miscellaneous function
Function Description

The UUID_SHORT() function returns a "short" Universally Unique Identifier as a 64-bit unsigned integer.

The value of UUID_SHORT() is guaranteed to be unique if the following conditions are met:

The server ID of the current host is unique among your master and slave servers and ranges from 0 to 255.

The system time for the server was not reset after restarting mysqld.

Since mysqld restarts, the UUID_SHORT() function is being called no more than 16 million times per second on average.

SQL Examples for the UUID_SHORT function

 1
 2
 3
 4

SELECT uuid_short();
SELECT UUID_short();

uuid_short()
bigint(21)
100254783826296834
UUID_short()
bigint(21)
100254783826296835
The examples were created with the MyWAY SQL manager: Download

How to use the UUID_SHORT() function in MySQL and MariaDB databases

In MySQL and MariaDB the UUID_SHORT() function is used to generate a new 64-bit UUID (Universally Unique Identifier) ​​value. The function can be used directly in SQL statements or within SQL queries, requires no arguments, and returns a randomly generated numeric value that is unique within the server or session.

The UUID_SHORT() function can be used to generate unique numeric identifiers that are shorter than standard UUIDs, for example when a shorter identifier suffices or the storage efficiency of it requires. The function can be used to generate unique primary keys for tables, for example in applications where a larger numeric range is required compared to traditional auto-incrementing integer values. In testing and development, the function can be used to generate unique identifiers for these purposes, such as populating databases with dummy data or creating temporary tables.

The generated values ​​cannot be guaranteed to be globally unique, as is the case with the standard UUID format. Also, the numeric range of UUID_SHORT() is limited to 64 bits.
UTC_TIMEUTC_TIMESTAMPUUIDUUID_SHORTUUID_TO_BINVAR_POPVAR_SAMP

Further MySQL und MariaDB SQL Miscellaneous functions

BIN_TO_UUIDBIN_TO_UUID(Binary string [, Swap])
More about BIN_TO_UUID Function

GET_LOCKGET_LOCK()

INET6_ATONINET6_ATON(String)
More about INET6_ATON Function

INET6_NTOAINET6_NTOA(Binary string)
More about INET6_NTOA Function

INET_ATONINET_ATON(String)
More about INET_ATON Function

INET_NTOAINET_NTOA(Value)
More about INET_NTOA Function

IS_FREE_LOCKIS_FREE_LOCK()

IS_IPV4IS_IPV4(String)
More about IS_IPV4 Function

IS_IPV4_COMPATIS_IPV4_COMPAT(String)

IS_IPV4_MAPPEDIS_IPV4_MAPPED(String)

IS_IPV6IS_IPV6(String)
More about IS_IPV6 Function

IS_USED_LOCKIS_USED_LOCK()

IS_UUIDIS_UUID(String)
More about IS_UUID Function

MASTER_GTID_WAITMASTER_GTID_WAIT()

MASTER_POS_WAITMASTER_POS_WAIT()

NAME_CONSTNAME_CONST(Name, Value)
More about NAME_CONST Function

RELEASE_ALL_LOCKSRELEASE_ALL_LOCKS()

RELEASE_LOCKRELEASE_LOCK()

SYS_GUIDSYS_GUID()
More about SYS_GUID Function

UUIDUUID()
More about UUID Function

UUID_TO_BINUUID_TO_BIN(String [, Swap])
More about UUID_TO_BIN Function

Numeric functionsString functionsRegular ExpressionsDate and Time functions
Comparison functionsEncryption & CompressionConversion functionsNULL functions
Aggregate functionsWindow functionsJSON functionsGeometric functions
Sequence functionsInformation functionsDynamic ColumnsMiscellaneous functions
More information about the UUID_SHORT SQL function: mysql.com and mariadb.com
Updated: 2023-09-17ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer