General MySQL Oracle SQL Server

<< < … 10 11 12 13 14 15 16 17 > >>   ∑:386  Sort:Date

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, 2013🔥, 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, 2012🔥, 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, 2007🔥, 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, 1994🔥, 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, 1983🔥, 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, 1954🔥, 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, 1936🔥, 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, 1935🔥, 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, 1913🔥, 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, 1909🔥, 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&gt;&a... 2026-04-13, 1905🔥, 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, 1889🔥, 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, 1878🔥, 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...

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, 1864🔥, 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, 1861🔥, 0💬

RELEASE_ALL_LOCKS() - Release All Locks
How to release all locks associated with the current connection session using the RELEASE_ALL_LOCKS() function? RELEASE_ALL_LOCKS(lock) is a MySQL built-in function that releases all locks associated with the current connection session. It returns the number of locks released. For example: SELECT GE... 2023-12-20, 1860🔥, 0💬

Removed: DECODE() - Decoding Data with Password
How to decode a byte sequence generated from the ENCODE() function using the DECODE() function? DECODE(cipher, pass) is a MySQL built-in function that encodes a byte sequence generated from the ENCODE() function. Note that DECODE() is no longer supported. It was: Introduced MySQL 4.0. Removed in MyS... 2024-10-14, 1854🔥, 0💬

Removed: PASSWORD() - Generating Password Hash
How to convert a password into a hash value with the default hashing algorithm using the PASSWORD() function? PASSWORD(password) is a MySQL built-in function that converts a password into a hash value with the default hashing algorithm. Note that PASSWORD() is no longer supported. It was: Introduced... 2024-05-15, 1850🔥, 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, 1844🔥, 0💬

SLEEP() - Holding Statement Execution
How to hold the statement execution for some time using the SLEEP() function? SLEEP(sec) is a MySQL built-in function that holds the execution of the current statement for sec seconds. For example: SELECT SYSDATE(), SLEEP(2), SYSDATE(); -- +---------------------+------- ---+---------------------+-- ... 2023-12-19, 1805🔥, 0💬

Removed: ENCRYPT() - Unix crypt() Hash Algorithm
How to generate a hash value with the Unix crypt() algorithm using the ENCRYPT() function? ENCRYPT(bytes) is a MySQL built-in function that generates a hash value with the Unix crypt() algorithm. Note that ENCRYPT() is no longer supported. It was: Introduced MySQL 4.0. Removed in MySQL 8.0. Related ... 2024-05-15, 1802🔥, 0💬

Removed MySQL Functions
Where to find answers to frequently asked questions about Removed MySQL Built-in Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team about Removed MySQL Built-in Functions: Removed: ENCODE() - Encoding Data with Password Removed: DECODE() - Decodi... 2024-10-14, 1801🔥, 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, 1798🔥, 0💬

RELEASE_LOCK() - Release Lock Instance
How to release an instance of a given lock associated with the current connection session using the RELEASE_LOCK() function? RELEASE_LOCK(lock) is a MySQL built-in function that releases an instance of a given lock associated with the current connection session. It returns 1 if released Successfully... 2023-12-20, 1798🔥, 0💬

<< < … 10 11 12 13 14 15 16 17 > >>   ∑:386  Sort:Date

General MySQL Oracle SQL Server