General MySQL Oracle SQL Server

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

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, 1507🔥, 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, 1501🔥, 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, 1500🔥, 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, 1484🔥, 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...

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, 1478🔥, 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, 1478🔥, 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, 1469🔥, 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, 1467🔥, 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, 1459🔥, 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, 1457🔥, 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, 1451🔥, 0💬

JSON_SCHEMA_VALID() - JSON Schema Validation
How to validate a JSON value against a JSON schema using the JSON_SCHEMA_VALID() function? JSON_SCHEMA_VALID(schema, json) is a MySQL built-in function that validates a JSON value against a given JSON schema. For example: SET @schema = '{ "id": "http://json-schema.org/geo", "$schema": "http://json-s... 2024-11-23, 1437🔥, 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, 1437🔥, 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, 1428🔥, 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, 1422🔥, 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, 1407🔥, 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, 1392🔥, 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, 1380🔥, 0💬

SQRT() - Square Root of X
How to calculate the square root of a given number using the SQRT() function? SQRT(X) is a MySQL built-in function that calculates the square root of a given number. For example: SELECT SQRT(2), SQRT(4), SQRT(8); -- +--------------------+-------- -+--------------------+-- | SQRT(2) | SQRT(4) | SQRT(... 2023-11-14, 1373🔥, 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, 1350🔥, 0💬

CONNECTION_ID() - Thread ID of Current Connection
How to obtain the connection ID of the current connection using the CONNECTION_ID() function? CONNECTION_ID() is a MySQL built-in function that returns the connection ID of the current connection. The connection ID is also referred as thread ID or process ID. For example: SELECT CONNECTION_ID(); -- ... 2024-07-15, 1339🔥, 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, 1338🔥, 0💬

VAR_SAMP() - Sample Standard Variance
How to calculate the sample standard variance of a field expression in result set groups using the VAR_SAMP() function? VAR_SAMP(expr) is a MySQL built-in aggregate function that calculates the sample standard variance of a field expression in result set groups. For example: SELECT help_category_id,... 2023-12-01, 1324🔥, 0💬

YEARWEEK() - Year Week Combination
How to calculate the year week combination from a given date using the YEARWEEK() function? YEARWEEK(date, mode) is a MySQL built-in function that calculates the year week combination from a given date. For example: SELECT YEARWEEK('2024-03-04'), WEEK('2024-03-04'); -- +------------------------+---- ... 2023-11-16, 1320🔥, 0💬

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

General MySQL Oracle SQL Server