General MySQL Oracle SQL Server

<< < … 50 51 52 53 54 55 56 57 > >>   ∑:1360  Sort:Date

UNCOMPRESSED_LENGTH() - Uncompressed Data Length
How to calculate the original data length of a compressed byte string using the UNCOMPRESSED_LENGTH() function? UNCOMPRESSED_LENGTH(str) is a MySQL built-in function that returns the original data length of a given compressed byte string. For example: SET @bin = x'37000000789C738BF44C4ECD2B49 2DD24BC... 2024-12-18, 1966🔥, 0💬

LAG() - N-Row before Current Row within Window
How to evaluate a field expression on n-row before the current row in the current result set window using the LAG() function? LAG(exp, n, default) is a MySQL built-in window function that evaluates a field expression on n-row before the current row in the current result set window. For example: SELE... 2024-09-28, 1962🔥, 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, 1937🔥, 0💬

MySQL Functions on Character String Values
Where to find reference information and tutorials on MySQL database functions on string values? I want to know how to use SUBSTRING(), REPLACE() and other character string related functions. Here is a collection of reference information and tutorials on MySQL database functions on string values comp... 2023-11-10, 1900🔥, 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, 1899🔥, 0💬

JSON_VALID() - Validating JSON Value
How to verify if value is a JSON (JavaScript Object Notation) value using the JSON_VALID() function? JSON_VALID(val) is a MySQL built-in function that returns 1 if the given value is a valid JSON value. For example: SELECT JSON_VALID('hello'), JSON_VALID('"hello"'); -- +---------------------+------- ... 2023-12-17, 1854🔥, 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, 1852🔥, 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, 1848🔥, 0💬

FIRST_VALUE() - First Value of Result Set Window
How to obtain the first value of a field expression in the current result set window using the FIRST_VALUE() function? FIRST_VALUE(exp) is a MySQL built-in window function that returns the first value of a field expression in the current result set window. For example: SELECT help_topic_id AS tip, h... 2024-09-28, 1819🔥, 0💬

LAST_VALUE() - Last Value of Result Set Window
How to obtain the last value of a field expression in the current result set window using the LAST_VALUE() function? LAST_VALUE(exp) is a MySQL built-in window function that returns the last value of a field expression in the current result set window. For example: SELECT help_topic_id AS tip, help_... 2024-09-28, 1777🔥, 0💬

MySQL Functions on System Information
Where to find reference information and tutorials on MySQL database functions on System Information? I want to know how to use DATABASE(), VERSION() and other functions. Here is a collection of reference information and tutorials on MySQL database functions on System Information compiled by FYIcente... 2024-07-15, 1774🔥, 0💬

RANK() - Vale Rank of Sorted Values
How to calculate the value rank of the sorting field expression in the current result set window using the RANK() function? RANK(n) is a MySQL built-in window function that calculates the value rank of the sorting field expression in the current result set window. For example: SELECT help_topic_id A... 2024-09-12, 1762🔥, 0💬

Removed: DES_ENCRYPT() - DES Data Encryption
How to encrypt data with the DES (Data Encryption Standard) algorithm using the DES_ENCRYPT() function? DES_ENCRYPT(clear, key) is a MySQL built-in function that encrypts data with the DES (Data Encryption Standard) algorithm. Note that DES_ENCRYPT() is no longer supported. It was: Introduced MySQL ... 2024-10-14, 1752🔥, 0💬

NTILE() - Dividing Window into N Tiles
How to divid result set window into N tiles and return the tile position using the NTILE() function? NTILE(n) is a MySQL built-in window function that divides result set window into n tiles and returns the tile position of the current row. For example: SELECT help_topic_id AS tip, help_category_id A... 2024-09-12, 1744🔥, 0💬

MAKE_SET() - Filtering List with Binary Set
How to filter a list of strings with a binary set provided as an integer using the MAKE_SET() function? MAKE_SET(bits, str1, str2, ...) is a MySQL built-in function that filters a list of strings with a binary set provided as an integer. It loops through every bit of the given integer "bits" startin... 2023-12-20, 1741🔥, 0💬

CRC32() - Cyclic Redundancy Check 32-Bit
How to calculate the 32-bit CRC (Cyclic Redundancy Check) value using the CRC32() function? CRC32(str) is a MySQL built-in function that calculates the 32-bit CRC (Cyclic Redundancy Check) value of a given character string and returns it as an integer. For example: SELECT CRC32('MySQL'), HEX(CRC32('... 2024-07-15, 1735🔥, 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, 1711🔥, 0💬

Calling MySQL Built-in Functions
Where to find answers to frequently asked questions about calling MySQL Built-in Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team about calling MySQL Built-in Functions: Function Name Case Insensitive Function Argument Modifier Variable Number ... 2023-11-14, 1692🔥, 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, 1676🔥, 0💬

Removed: DES_DECRYPT() - DES Data Decryption
How to decrypt data with the DES (Data Encryption Standard) algorithm using the DES_DECRYPT() function? DES_DECRYPT(cipher, key) is a MySQL built-in function that decrypts data with the DES (Data Encryption Standard) algorithm. Note that DES_DECRYPT() is no longer supported. It was: Introduced MySQL... 2024-10-14, 1675🔥, 0💬

MySQL Functions on Result Set Windows
Where to find reference information and tutorials on MySQL database functions on Result Set Windows? I want to know how to use FIRST_VALUE(), ROW_NUMBER() and other window functions. Here is a collection of reference information and tutorials on MySQL database functions on Result Set Windows compile... 2024-05-15, 1649🔥, 0💬

LEAD() - N-Row after Current Row within Window
How to evaluate a field expression on n-row after the current row in the current result set window using the LEAD() function? LEAD(exp, n, default) is a MySQL built-in window function that evaluates a field expression on n-row after the current row in the current result set window. For example: SELE... 2024-09-28, 1642🔥, 0💬

Window Functions
What Are Window Functions? A Window Function is a function that can perform calculations over a window of rows referenced from the current row in query result. A window function is called with a OVER clause in the following syntax: window_function(...) OVER window where window is one of the followin... 2024-05-15, 1636🔥, 0💬

BENCHMARK() - Repeating Expression Evaluation
How to evaluate an expression repeatedly for benchmark testing using the BENCHMARK() function? BENCHMARK(count, exp) is a MySQL built-in function that evaluates an expression repeatedly for benchmark testing and returns 0. For example: SELECT BENCHMARK(1000000, AES_ENCRYPT('hello','goodbye') );-- +-... 2024-07-17, 1603🔥, 2💬

💬 2024-07-17 Iqra Technology: This is a great overview of the `BENCHMARK()` function in MySQL! Your examples clearly illustrate how it can be used to evaluate...

<< < … 50 51 52 53 54 55 56 57 > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server