General MySQL Oracle SQL Server

1 2 3 4 5 6 … > >>   ∑:386  Sort:Rank

INET_ATON() - IP Address String to Number
How to convert an IP address from string format to number using the INET_ATON() function? INET_ATON(ip) is a MySQL built-in function that converts an IP address from string format to number. It uses the following conversion formula: INET_ATON('p 1 .p 2 .p 3 .p 4 ') = INET_ATON(p 1 ×256 3 + p 2 ×256 ... 2026-07-13, 2032🔥, 0💬

GREATEST() - Finding the Greatest/Maximum Value
How to find the greatest (maximum) value of a given list of values using the GREATEST() function? GREATEST(val1, val2, ...) is a MySQL built-in function that returns the greatest (maximum) value of a given list of values. For example: SELECT GREATEST(70, 89, 73, 99, 101, 110, 116, 101, 114); -- +---... 2026-07-13, 1845🔥, 0💬

ISNULL() - Detecting NULL Value
How to detect a NULL value using the ISNULL() function? ISNULL(val) is a MySQL built-in function that returns 1 if the given value is NULL, 0 otherwise. For example: SELECT ISNULL(1+1); -- +-------------+ -- | ISNULL(1+1) | -- +-------------+ -- | 0 | -- +-------------+ SELECT ISNULL(1/0); -- +-----... 2026-07-13, 1603🔥, 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, 2106🔥, 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, 1904🔥, 0💬

IS_IPV4_MAPPED() - IPv4-Mapped IPv6 Address
How to detect an IPv6 Address that is IPv4 compatible using the IS_IPV4_MAPPED() function? IS_IPV4_MAPPED(ip) is a MySQL built-in function that returns 1 if the given IPv6 address is IPv4-mapped, 0 otherwise. The IPv6 address must be given in number format. An IPv4-mapped IPv6 address has 10 leading... 2026-04-13, 1655🔥, 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, 3057🔥, 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, 1967🔥, 0💬

CAST() - Casting Expression to Value
How to cast an expression to a value of the given data type using the CAST() function? CAST(exp AS type) is a MySQL built-in function that casts an expression to a value of the given data type. For example: SET @exp = '-1.99 USD'; SELECT @exp, CAST(@exp AS SIGNED INTEGER), CAST(@exp AS UNSIGNED INTE... 2026-03-22, 1682🔥, 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, 3995🔥, 0💬

IS_IPV4() - Detecting IPv4 Address
How to detect an IPv4 Address using the IS_IPV4() function? IS_IPV4(ip) is a MySQL built-in function that returns 1 if the given value is a valid IPv4 address, 0 otherwise. For example: SELECT IS_IPV4('10.0.5.9'), IS_IPV4('10.0.5.256'); -- +---------------------+------- ----------------+-- | IS_IPV4... 2026-02-02, 3574🔥, 0💬

IS_IPV4_COMPAT() - IPv4-Compatible IPv6 Address
How to detect an IPv6 Address that is IPv4 compatible using the IS_IPV4_COMPAT() function? IS_IPV4_COMPAT(ip) is a MySQL built-in function that returns 1 if the given IPv6 address is IPv4-compatible, 0 otherwise. The IPv6 address must be given in number format. An IPv4-compatible IPv6 address has 12... 2026-02-02, 2897🔥, 0💬

IS_IPV6() - Detecting IPv6 Address
How to detect an IPv4 Address using the IS_IPV6() function? IS_IPV6(ip) is a MySQL built-in function that returns 1 if the given value is a valid IPv6 address, 0 otherwise. For example: SELECT IS_IPV4('10.0.5.9'), IS_IPV4('10.0.5.256'); -- +---------------------+------- ----------------+-- | IS_IPV4... 2026-01-24, 4304🔥, 0💬

UPDATEXML() - Updating Child Element in XML
How to update a child element in an XML document at a given location using the UPDATEXML() function? UPDATEXML(xml, path, subxml) is a MySQL built-in function that updates a child element in an XML document at a given location. For example: SET @xml = ' X Y '; SELECT UPDATEXML(@xml, '/a', ' Z '); +-... 2026-01-24, 3810🔥, 0💬

CHARSET() - Detecting Character Set Name
How to detect the character set name associated to a given character string using the CHARSET() function? CHARSET(str) is a MySQL built-in function that returns the character set name associated to a given character string. A character set name refers to a set of rules to encode a set of characters ... 2025-10-24, 3866🔥, 0💬

VALUES() - Column Value for "ON DUPLICATE KEY UPDATE"
How to obtain the inserting value of given column in the "ON DUPLICATE KEY UPDATE" clause using the VALUES() function? VALUES(col) is a MySQL built-in function that returns the inserting value of a given column and use it in the "ON DUPLICATE KEY UPDATE" clause. For example: CREATE TABLE MyTable (id... 2025-10-24, 2830🔥, 0💬

COERCIBILITY() - Character Collation Coercibility
How to detect the collation coercibility associated to a given character string using the COERCIBILITY() function? COERCIBILITY(str) is a MySQL built-in function that returns the collation coercibility associated to a given character string. A collation coercibility refers to the coercibility index,... 2025-10-14, 6029🔥, 0💬

COLLATION() - Detecting Character Collation Name
How to detect the character collation name associated to a given character string using the COLLATION() function? COLLATION(str) is a MySQL built-in function that returns the character collation name associated to a given character string. A character collation name refers to a set of rules to sort ... 2025-10-14, 2192🔥, 0💬

FORMAT_BYTES() - Formatting Bytes in Readable Units
How to format a number of bytes in a human-readable unit using the FORMAT_BYTES() function? FORMAT_BYTES(con) is a MySQL built-in function that converts a number of bytes in a human-readable unit of KiB, MiG, GiB, TiB, PiB or EiB. For example: SELECT FORMAT_BYTES(9), FORMAT_BYTES(9*1024), FORMAT_BYT... 2025-09-24, 5496🔥, 0💬

FORMAT_PICO_TIME() - Formatting Picoseconds in Readable Units
How to format a number of picoseconds in a human-readable unit using the FORMAT_PICO_TIME() function? FORMAT_PICO_TIME(con) is a MySQL built-in function that converts a number of picoseconds in a human-readable unit of ps, ns, ms, s, min, h, or d. For example: SELECT FORMAT_PICO_TIME(9), FORMAT_PICO... 2025-09-24, 2648🔥, 0💬

CURRENT_USER() - Authentication Name of Current User
How to obtain the authentication name of the current user using the CURRENT_USER() function? CURRENT_USER() is a MySQL built-in function that returns the authentication name of the current user. The authentication name is a combination of "User" and "Host" columns in the mysql.user table and used to... 2025-06-18, 4610🔥, 0💬

DATABASE() - Name of Current Database
How to obtain the name of the current database using the DATABASE() function? DATABASE() is a MySQL built-in function that returns the name of the current database. For example: USE mysql; Database changed SELECT DATABASE(); -- +------------+ -- | DATABASE() | -- +------------+ -- | mysql | -- +----... 2025-06-18, 4529🔥, 0💬

FOUND_ROWS() - Row Count from Last SELECT Statement
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function? FOUND_ROWS() is a MySQL built-in function that returns the number of rows found by the last SELECT statement. For example: SELECT help_topic_id, name FROM mysql.help_topic; -- +---------------+------... 2025-04-11, 8640🔥, 0💬

ICU_VERSION() - ICU (International Components for Unicode) Version
How to obtain the version number of the ICU (International Components for Unicode) library using the ICU_VERSION() function? ICU_VERSION() is a MySQL built-in function that returns the version number of the ICU (International Components for Unicode) library. For example: SELECT ICU_VERSION(); -- +--... 2025-04-11, 6603🔥, 0💬

1 2 3 4 5 6 … > >>   ∑:386  Sort:Rank

General MySQL Oracle SQL Server