JSON_OBJECT

Syntax

JSON_OBJECT([key, value[, key, value] ...])

Description

Returns a JSON object containing the given key/value pairs. The key/value list can be empty.

An error will occur if there are an odd number of arguments, or any key name is NULL.

Example

SELECT JSON_OBJECT("id", 1, "name", "Monty"); +---------------------------------------+ | JSON_OBJECT("id", 1, "name", "Monty") | +---------------------------------------+ | {"id": 1, "name": "Monty"} | +---------------------------------------+

See also

• JSON_MAKE_OBJECT, the CONNECT storage engine function

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