JSON (JavaScript Object Notation) functions

SON (JavaScript Object Notation) functions in MySQL are used for working with JSON data. These functions allow you to parse and manipulate JSON objects and arrays within SQL queries. Here is a list of common JSON functions, along with real-time examples and detailed explanations for each:

JSON_OBJECT():
- JSON_OBJECT() creates a JSON object from a list of key-value pairs.
Example:
```
sqlCopy code
SELECT JSON_OBJECT('name', 'John', 'age', 30) AS person_json;
```
Output: The person_json column will contain the JSON object {"name": "John", "age": 30}.
JSON_ARRAY():
- JSON_ARRAY() creates a JSON array from a list of values.
Example:
```
sqlCopy code
SELECT JSON_ARRAY('apple', 'banana', 'cherry') AS fruit_array;
```
Output: The fruit_array column will contain the JSON array ["apple", "banana", "cherry"].
JSON_KEYS():
- JSON_KEYS() returns an array of keys from a JSON object.
Example:
```
sqlCopy code
SELECT JSON_KEYS('{"name": "Alice", "age": 25}') AS keys_array;
```
Output: The keys_array column will contain the JSON array ["name", "age"].
JSON_EXTRACT():
- JSON_EXTRACT() retrieves a specific value from a JSON document based on a path.
Example:
```
sqlCopy code
SELECT JSON_EXTRACT('{"info": {"name": "Tom", "age": 35}}', '$.info.name') AS person_name;
```
Output: The person_name column will contain the value "Tom".
JSON_UNQUOTE():
- JSON_UNQUOTE() removes quotes from a JSON string.
Example:
```
sqlCopy code
SELECT JSON_UNQUOTE('"quoted_string"') AS unquoted_string;
```
Output: The unquoted_string column will contain the string quoted_string without quotes.
JSON_ARRAY_APPEND():
- JSON_ARRAY_APPEND() adds an element to the end of a JSON array.
Example:
```
sqlCopy code
SELECT JSON_ARRAY_APPEND('[1, 2, 3]', '$', 4) AS updated_array;
```
Output: The updated_array column will contain the JSON array [1, 2, 3, 4].
JSON_ARRAY_INSERT():
- JSON_ARRAY_INSERT() inserts an element into a JSON array at a specified position.
Example:
```
sqlCopy code
SELECT JSON_ARRAY_INSERT('[1, 2, 3]', '$[1]', 4) AS updated_array;
```
Output: The updated_array column will contain the JSON array [1, 4, 2, 3].
JSON_MERGE():
- JSON_MERGE() combines two or more JSON objects into a single JSON object.
Example:
```
sqlCopy code
SELECT JSON_MERGE('{"name": "Alice"}', '{"age": 25}') AS merged_json;
```
Output: The merged_json column will contain the JSON object {"name": "Alice", "age": 25}.

These JSON functions in MySQL are valuable for working with JSON data stored in database columns or as part of query results. They enable you to create, manipulate, and extract data from JSON documents within SQL queries.