General MySQL Oracle SQL Server

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

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, 1425🔥, 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, 1227🔥, 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, 1178🔥, 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, 1592🔥, 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, 1167🔥, 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, 1674🔥, 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, 1160🔥, 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, 1747🔥, 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, 1462🔥, 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, 1450🔥, 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, 1318🔥, 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, 2351🔥, 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, 2220🔥, 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, 5313🔥, 0💬

LAST_INSERT_ID() - Last Value of AUTO_INCREMENT Column
How to obtain the last inserted value of an AUTO_INCREMENT column using the LAST_INSERT_ID() function? LAST_INSERT_ID() is a MySQL built-in function that returns the last inserted value of an AUTO_INCREMENT column. For example: CREATE TABLE MyTable (id INTEGER AUTO_INCREMENT, comment CHAR(80), PRIMA... 2025-04-11, 2737🔥, 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, 2591🔥, 0💬

JSON_STORAGE_SIZE() - Storage Size of JSON Value
How to calculate the storage size of a JSON (JavaScript Object Notation) value using the JSON_STORAGE_SIZE() function? JSON_STORAGE_SIZE(json) is a MySQL built-in function that calculates the storage size of a JSON (JavaScript Object Notation) value or table column. For example: SELECT JSON_STORAGE_... 2025-03-12, 35155🔥, 0💬

JSON_UNQUOTE() - Unquoting JSON String
How to convert a JSON (JavaScript Object Notation) quoted string into a regular character string using the JSON_UNQUOTE() function? JSON_UNQUOTE(json) is a MySQL built-in function that converts a JSON string into a regular character string, by removing the enclosing double-quotes and restoring any e... 2025-03-12, 3227🔥, 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, 3131🔥, 0💬

MySQL Functions for Encryption and Compression
Where to find reference information and tutorials on MySQL database functions for Encryption and Compression? I want to know how to use COMPRESS(), ENCRYPT() and other related functions. Here is a collection of reference information and tutorials on MySQL database functions for Encryption and Compre... 2025-03-12, 2950🔥, 0💬

JSON_TYPE() - Detecting Type of JSON Value
How to detect the type of a JSON (JavaScript Object Notation) value using the JSON_TYPE() function? JSON_TYPE(json) is a MySQL built-in function that returns the data type of a JSON (JavaScript Object Notation) value. For example: SELECT JSON_TYPE('[]'), JSON_TYPE('{}'); -- +-----------------+------... 2025-03-12, 2458🔥, 0💬

ROW_COUNT() - Affected Rows from Last DML Statement
How to obtain the affected row count from the last DML statement (INSERT, UPDATE or DELETE) using the ROW_COUNT() function? ROW_COUNT() is a MySQL built-in function that returns the affected row count from the last DML (Data Manipulation Language) statement (INSERT, UPDATE and DELETE). For example: ... 2025-02-16, 3027🔥, 0💬

SCHEMA() - Synonym for DATABASE()
What's the difference between SCHEMA() and DATABASE() functions? SCHEMA() is a synonym for the DATABASE() function. Related MySQL functions: DATABASE() - Name of Current Database SCHEMA() - Synonym for DATABASE()   ⇒ SESSION_USER() - Synonym for USER() ⇐ ROW_COUNT() - Affected Rows from Last DML St... 2025-02-16, 2914🔥, 0💬

PS_CURRENT_THREAD_ID() - PS Thread ID of Current Connect
How to obtain the performance schema thread id of the current connection using the PS_CURRENT_THREAD_ID() function? PS_CURRENT_THREAD_ID() is a MySQL built-in function that returns the performance schema thread id of the current connection. For example: SELECT PS_CURRENT_THREAD_ID(); -- +-----------... 2025-02-16, 2770🔥, 0💬

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

General MySQL Oracle SQL Server