JSON_DETAILED

Explore JSON_DETAILED in MariaDB. Also known as JSON_PRETTY, this function formats JSON documents with indentation and newlines to emphasize nested structures for readability.

Syntax

JSON_DETAILED(json_doc[, tab_size])
JSON_PRETTY(json_doc[, tab_size])

Description

Represents JSON in the most understandable way emphasizing nested structures.

Current

JSON_PRETTY is an alias for JSON_DETAILED .

< 10.10.3 / 10.9.5 / 10.8.7 / 10.7.8 / 10.6.12 / 10.5.19 / 10.4.28

Example

SET @j = '{ "A":1,"B":[2,3]}';

SELECT @j;
+--------------------+
| @j                 |
+--------------------+
| { "A":1,"B":[2,3]} |
+--------------------+

SELECT JSON_DETAILED(@j);
+------------------------------------------------------------+
| JSON_DETAILED(@j)                                          |
+------------------------------------------------------------+
| {
    "A": 1,
    "B": 
    [
        2,
        3
    ]
} |
+------------------------------------------------------------+

See Also

• JSON video tutorial covering JSON_DETAILED.

_{This page is licensed: CC BY-SA / Gnu FDL}