JSON_COMPACT()

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

SET @json = ' {
    "c"  : 123.456 ,
      "b" :   1,
    "a":  42
    } ';
SELECT JSON_COMPACT(@json);
+----------------------------+
| JSON_COMPACT(@json)        |
+----------------------------+
| {"c":123.456,"b":1,"a":42} |
+----------------------------+
CREATE TABLE json_compact_example (
  j1 JSON,
  j2 JSON
);
INSERT INTO json_compact_example VALUES (' [  1 , 2 ,3  ] ', ' {  "a"  : "A"  }');
SELECT JSON_COMPACT(j1), JSON_COMPACT(j2)
FROM json_compact_example;
+------------------+------------------+
| JSON_COMPACT(j1) | JSON_COMPACT(j2) |
+------------------+------------------+
| [1,2,3]          | {"a":"A"}        |
+------------------+------------------+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Added in MariaDB Community Server 10.2.4.

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES