MySQL Functions for Miscellaneous Purposes

Q

Where to find reference information and tutorials on MySQL database functions for Miscellaneous Purposes? I want to know how to use CAST(), SLEEP() and other miscellaneous functions.

✍: FYIcenter.com

A

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

CAST() - Casting Expression to Value

COALESCE() - Finding First Non-NULL Value

CONVERT() - Character Set Conversion

DEFAULT() - Table Column Default Value

EXTRACTVALUE() - Extracting Text Content from XML

GET_LOCK() - Requesting User Defined Lock

GREATEST() - Finding the Greatest/Maximum Value

IF() - Conditional Value Selection

IFNULL() - Replacing NULL Value

INET_ATON() - IP Address String to Number

INET_NTOA() - IP Address Number to String

INET6_ATON() - IPv6 Address String to Number

INET6_NTOA() - IPv6 Address Number to String

IS_FREE_LOCK() - Checking Lock Status

IS_IPV4() - Detecting IPv4 Address

IS_IPV4_COMPAT() - IPv4-Compatible IPv6 Address

IS_IPV4_MAPPED() - IPv4-Mapped IPv6 Address

IS_IPV6() - Detecting IPv6 Address

IS_USED_LOCK() - Checking Lock Owner

ISNULL() - Detecting NULL Value

LEAST() - Finding the Least/Minimum Value

NAME_CONST() - PS Thread ID of Given Connect

NULLIF() - NULL on Equal Values

RELEASE_ALL_LOCKS() - Release All Locks

RELEASE_LOCK() - Release Lock Instance

SLEEP() - Holding Statement Execution

UPDATEXML() - Updating Child Element in XML

VALUES() - Column Value for "ON DUPLICATE KEY UPDATE"

⇒ CAST() - Casting Expression to Value

⇐ VERSION() - Version Number of MySQL Server

⇑⇑ MySQL Function References

2026-03-22, 2609🔥, 0💬

INET6_NTOA() - IPv6 Address Number to String
How to convert an IPv6 address from number format to string using the INET6_NTOA() function? INET6_NTOA(int) is a MySQL built-in function that converts an IPv6 address from number format to string. For example: SET @ipv6 = UNHEX('FDFE0000000000005A55CAF FFEFA9089');SELECT HEX(@ipv6), INET6_NTOA(@ipv... 2026-02-02, 2753🔥, 0💬

MySQL Functions for Miscellaneous Purposes
Where to find reference information and tutorials on MySQL database functions for Miscellaneous Purposes? I want to know how to use CAST(), SLEEP() and other miscellaneous functions. Here is a collection of reference information and tutorials on MySQL database functions for Miscellaneous Purposes co... 2026-03-22, 2610🔥, 0💬

JSON_SCHEMA_VALID() - JSON Schema Validation
How to validate a JSON value against a JSON schema using the JSON_SCHEMA_VALID() function? JSON_SCHEMA_VALID(schema, json) is a MySQL built-in function that validates a JSON value against a given JSON schema. For example: SET @schema = '{ "id": "http://json-schema.org/geo", "$schema": "http://json-s... 2024-11-23, 2161🔥, 0💬

JSON_VALUE() - Converting JSON Value
How to convert a JSON value to a given MySQL data type using the JSON_VALUE() function? JSON_VALUE(json, path RETURNING type on_empty on_error) is a MySQL built-in function that converts a JSON value to a given MySQL data type. The input JSON value can be a member of a parent JSON array or object. F... 2024-11-23, 1828🔥, 0💬

JSON_TABLE() - Inline Table with JSON Array
How to create an inline table with a JSON Array using the JSON_TABLE() function? JSON_TABLE(json, path COLUMNS (column_list) AS alias) is a MySQL built-in function that creates an inline table by parsing JSON array members. For example: the following statement creates a 1-column table with string me... 2024-11-23, 1787🔥, 0💬

INET_NTOA() - IP Address Number to String
How to convert an IP address from number format to string using the INET_NTOA() function? INET_NTOA(int) is a MySQL built-in function that converts an IP address from number format to string. It uses the following conversion formula: INET_NTOA(int) = 'p 1 .p 2 .p 3 .p 4 ' where: p 1 = (int>&a... 2026-04-13, 1758🔥, 0💬

COALESCE() - Finding First Non-NULL Value
How to find the first non-NULL value from a list using the COALESCE() function? COALESCE(val1, val2, ...) is a MySQL built-in function that returns the first non-NULL value from a given list of values. For example: SELECT COALESCE(NULL, 'FYI', NULL, 3.14); -- +----------------------------- ------+--... 2026-03-22, 1640🔥, 0💬

INET6_ATON() - IPv6 Address String to Number
How to convert an IPv6 address from string format to number using the INET6_ATON() function? INET6_ATON(ip) is a MySQL built-in function that converts an IPv6 address from string format to number. But an IPv6 number is too big to be represented in decimal digits. So it is stored as a byte sequence, ... 2026-04-13, 1577🔥, 0💬

BIN() - Converting Integer to Binary String
How to convert an integer to a binary string using the BIN() function? BIN(int) is a MySQL built-in function that converts an integer to binary string. For example: SELECT BIN(1), BIN(2), BIN(4), BIN(8), BIN(16), BIN(1024); -- +--------+--------+--------+-- ------+---------+------------- +-- | BIN(1)... 2024-11-23, 1544🔥, 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.