MySQL Functions on JSON Values

Q

Where to find reference information and tutorials on MySQL database functions on JSON (JavaScript Object Notation) Values? I want to know how to use JSON_ARRAY(), JSON_OBJECT() and other JSON related functions.

✍: FYIcenter.com

A

Here is a collection of reference information and tutorials on MySQL database functions on JSON Values compiled by FYIcenter.com DBA team.

JSON_ARRAY() - Creating JSON Array

JSON_ARRAY_APPEND() - Appending Value to JSON Array

JSON_ARRAY_INSERT() - Inserting Value to JSON Array

JSON_CONTAINS() - Finding JSON in JSON

JSON_CONTAINS_PATH() - Finding Path in JSON

JSON_DEPTH() - Calculating Depth of JSON Value

JSON_EXTRACT() - Exacting Members from JSON

JSON_STORAGE_FREE() - Free Space in JSON Value

JSON_INSERT() - Inserting Members to JSON Value

JSON_KEYS() - Exacting Keys from JSON Object

JSON_LENGTH() - Calculating Length of JSON Value

JSON_MERGE() - Synonym for JSON_MERGE_PRESERVE()

JSON_MERGE_PATCH() - Merging JSON by Replacing Members

JSON_MERGE_PRESERVE() - Merging JSON with All Members

JSON_OBJECT() - Creating JSON Object

JSON_OVERLAPS() - Checking JSON Overlaps

JSON_PRETTY() - Validating JSON Value

JSON_QUOTE() - Quoting JSON String

JSON_REMOVE() - Removing JSON Child Members

JSON_REPLACE() - Replacing JSON Child Members

JSON_SCHEMA_VALID() - JSON Schema Validation

JSON_SCHEMA_VALIDATION_REPORT() - JSON Schema Validation Report

JSON_SEARCH() - Searching String in JSON

JSON_SET() - Inserting/updating JSON Child Members

JSON_STORAGE_SIZE() - Storage Size of JSON Value

JSON_TABLE() - Inline Table with JSON Array

JSON_TYPE() - Detecting Type of JSON Value

JSON_UNQUOTE() - Unquoting JSON String

JSON_VALID() - Validating JSON Value

JSON_VALUE() - Converting JSON Value

⇒ JSON_ARRAY() - Creating JSON Array

⇐ ROW_NUMBER() - Row Position in Result Set Window

⇑⇑ MySQL Function References

2023-12-10, 260🔥, 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, 331🔥, 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, 331🔥, 0💬

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

NULLIF() - NULL on Equal Values
How to generate NULL with equal values using the NULLIF() function? NULLIF(val1, val2) is a MySQL built-in function that returns NULL if the first argument equals the second, the first argument otherwise. For example: SELECT NULLIF('yes', 'yes'), NULLIF('yes', 'no'); -- +----------------------+-----. .. 2023-12-19, 314🔥, 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, 308🔥, 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, 303🔥, 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, 302🔥, 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, 285🔥, 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, 284🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.