{} (object_ construct)
On this page
Returns an OBJECT constructed from the arguments.
Syntax
{ [<key>: <value> [, <key>: <value> , ...]] }Arguments
<key>
The key in a key-value pair. Each key is a string value.
<value>
The value that is associated with the key. The value can be any data type.
Returns
Returns a value of type OBJECT.
Examples
This example shows how to construct a simple object:
SELECT { 'a': 1, 'b': 'BBBB', 'c': NULL };+----------------------------------+
| {'a': 1, 'b': 'BBBB', 'c': NULL} |
+----------------------------------+
| {"a":1,"b":"BBBB","c":NULL} |
+----------------------------------+