General MySQL Oracle SQL Server

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

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, 1997🔥, 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, 1994🔥, 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, 1978🔥, 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, 1960🔥, 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, 1924🔥, 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...

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

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, 1916🔥, 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, 1912🔥, 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, 1911🔥, 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, 1904🔥, 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, 1903🔥, 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, 1891🔥, 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, 1886🔥, 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, 1876🔥, 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, 1846🔥, 0💬

LEAST() - Finding the Least/Minimum Value
How to find the least (minimum) value of a given list of values using the LEAST() function? LEAST(val1, val2, ...) is a MySQL built-in function that returns the least (minimum) value of a given list of values. For example: SELECT LEAST(70, 89, 73, 99, 101, 110, 116, 101, 114); -- +------------------... 2023-12-19, 1844🔥, 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, 1834🔥, 0💬

VARIANCE() - Synonym for VAR_POP()
What's the difference between VARIANCE() and VAR_POP() functions? VARIANCE(expr) is a synonym for the VAR_POP(expr) function. Related MySQL functions: VAR_POP() - Population Standard Variance   ⇒ Window Functions ⇐ VAR_SAMP() - Sample Standard Variance ⇑ MySQL Functions on Aggregation Groups ⇑⇑ My... 2023-12-01, 1832🔥, 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, 1831🔥, 0💬

GET_LOCK() - Requesting User Defined Lock
How to request a user defined lock using the GET_LOCK() function? GET_LOCK(lock, timeout) is a MySQL built-in function that tries to obtain a user defined lock within a timeout period. It returns 1 if successful, 0 if failed. For example: SELECT GET_LOCK('MyLock', 60), IS_FREE_LOCK('MyLock'), IS_USE... 2023-12-20, 1825🔥, 0💬

UUID() - Generating UUID String
How to generate a UUID (Universal Unique IDentifier) string using the UUID() function? UUID() is a MySQL built-in function that returns a UUID (Universal Unique IDentifier) string. For example: SELECT UUID(), UUID(); -- +----------------------------- ---------+-------------------- ------------------+... 2023-12-08, 1809🔥, 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, 1803🔥, 0💬

NTH_VALUE() - N-th Value of Result Set Window
How to obtain the n-th value of a field expression in the current result set window using the NTH_VALUE() function? NTH_VALUE(exp, n) is a MySQL built-in window function that returns the n-th value of a field expression in the current result set window. For example: SELECT help_topic_id AS tip, help... 2024-09-12, 1789🔥, 0💬

CUME_DIST() - Cumulative Distribution of Sorted Values
How to calculate the cumulative distribution of the sorting field expression in the current result set window using the CUME_DIST() function? CUME_DIST() is a MySQL built-in window function that calculates the cumulative distribution of the sorting field expression in the current result set window. ... 2024-05-15, 1787🔥, 0💬

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

General MySQL Oracle SQL Server