JSON_NORMALIZE()
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
In 10.6 ES, 10.5 ES, 10.4 ES:
A description for this Function has not yet been added to this Documentation.
EXAMPLES
SET @json = ' {
"c" : 123.456 ,
"b" : 1,
"a": 42
} ';
SELECT JSON_NORMALIZE(@json);
+-------------------------------------+
| JSON_NORMALIZE(@json) |
+-------------------------------------+
| {"a":4.2E1,"b":1.0E0,"c":1.23456E2} |
+-------------------------------------+
CREATE TABLE json_compact_example (
j1 JSON,
j2 JSON
);
INSERT INTO json_compact_example VALUES (' [ 3.14159 , 0.5 ,99 ] ', ' { "a" : "A" }');
SELECT JSON_NORMALIZE(j1), JSON_NORMALIZE(j2)
FROM json_compact_example;
+--------------------------+--------------------+
| JSON_NORMALIZE(j1) | JSON_NORMALIZE(j2) |
+--------------------------+--------------------+
| [3.14159E0,5.0E-1,9.9E1] | {"a":"A"} |
+--------------------------+--------------------+