MySQL Functions on UUID Values

Q

Where to find reference information and tutorials on MySQL database functions on UUID (Universal Unique IDentifier) values? I want to know how to use UUID(), UUID_SHORT() and other UUID related functions.

✍: FYIcenter.com

A

Here is a collection of reference information and tutorials on MySQL database functions on UUID values compiled by FYIcenter.com DBA team.

BIN_TO_UUID() - Converting Binary to UUID

IS_UUID() - Validating UUID String Format

UUID() - Generating UUID String

UUID_SHORT() - Short 64-Bit UUID Integer

UUID_TO_BIN() - Converting UUID to Binary

⇒ BIN_TO_UUID() - Converting Binary to UUID

⇐ VALIDATE_PASSWORD_STRENGTH() - Password Strength Test

⇑⇑ MySQL Function References

2023-12-08, 1667🔥, 0💬

JSON_SET() - Inserting/updating JSON Child Members
How to insert or update child members of a JSON (JavaScript Object Notation) value using the JSON_SET() function? JSON_SET(json, path1, val1, path2, val2, ...) is a MySQL built-in function that inserts child members of a JSON value at given new locations, and replaces child numbers at given existing... 2025-03-12, 4117🔥, 0💬

SUM() - Total Value in Group
How to calculate the total value of a field expression in result set groups using the SUM() function? SUM(expr) is a MySQL built-in aggregate function that calculates the total value of a field expression in result set groups. For example: SELECT help_category_id, SUM(help_topic_id), COUNT(help_topi... 2023-12-01, 3475🔥, 0💬

JSON_QUOTE() - Quoting JSON String
How to convert a regular character string into a JSON (JavaScript Object Notation) string using the JSON_QUOTE() function? JSON_QUOTE(str) is a MySQL built-in function that converts a regular character string into a JSON string by quoting the string with double quotes. It replaces the double-quote c... 2023-12-10, 2045🔥, 0💬

IS_UUID() - Validating UUID String Format
How to validate a UUID (Universal Unique IDentifier) string using the IS_UUID() function? IS_UUID(uuid) is a MySQL built-in function that validates a UUID (Universal Unique IDentifier) string. It only checks if the given UUID is a 32-digit hexadecimal string or not. For example: SELECT IS_UUID('447f... 2023-12-08, 1863🔥, 0💬

JSON_PRETTY() - Validating JSON Value
How to encode a JSON (JavaScript Object Notation) value into a pretty-printing string using the JSON_PRETTY() function? JSON_PRETTY(json) is a MySQL built-in function that encodes a JSON (JavaScript Object Notation) value into a pretty-printing string. For example: SELECT JSON_PRETTY('["a",1,{"key1"... 2023-12-10, 1749🔥, 0💬

VARIANCE() - Synonym for VAR_POP()
What's the difference between VARIANCE() and VAR_POP() functions? VARIANCE(expr) is a synonym for the VAR_POP(expr) function. Related MySQL functions: VAR_POP() - Population Standard Variance ⇒ Window Functions ⇐ VAR_SAMP() - Sample Standard Variance ⇑ MySQL Functions on Aggregation Groups ⇑⇑ My... 2023-12-01, 1669🔥, 0💬

UUID() - Generating UUID String
How to generate a UUID (Universal Unique IDentifier) string using the UUID() function? UUID() is a MySQL built-in function that returns a UUID (Universal Unique IDentifier) string. For example: SELECT UUID(), UUID(); -- +----------------------------- ---------+-------------------- ------------------+... 2023-12-08, 1625🔥, 0💬

VAR_SAMP() - Sample Standard Variance
How to calculate the sample standard variance of a field expression in result set groups using the VAR_SAMP() function? VAR_SAMP(expr) is a MySQL built-in aggregate function that calculates the sample standard variance of a field expression in result set groups. For example: SELECT help_category_id,... 2023-12-01, 1611🔥, 0💬

YEARWEEK() - Year Week Combination
How to calculate the year week combination from a given date using the YEARWEEK() function? YEARWEEK(date, mode) is a MySQL built-in function that calculates the year week combination from a given date. For example: SELECT YEARWEEK('2024-03-04'), WEEK('2024-03-04'); -- +------------------------+---- ... 2023-11-16, 1530🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.