JSON
MySQL
JSON_OBJECT
MySQLMembuat JSON object dari pasangan key-value. Keys harus string.
Tipe hasil:
JSONDiperbarui: 7 Jan 2026Syntax
SQL
JSON_OBJECT([key, value[, key, value] ...])Parameter
keystringopsional
Nama property (harus string)
valueanyopsional
Nilai property (akan dikonversi ke JSON)
Contoh Penggunaan
Create JSON Object
SQL
1 SELECT JSON_OBJECT('name', 'John', 'age', 30) AS person;
Membuat object JSON dari key-value pairs.
Hasil
{"name": "John", "age": 30}
Dynamic Object
SQL
1 SELECT JSON_OBJECT( 2 'id', id, 3 'name', name, 4 'email', email 5 ) AS user_json 6 FROM users;
Membuat JSON dari kolom tabel.
Hasil
(JSON objects per row)
Nested Object
SQL
1 SELECT JSON_OBJECT( 2 'user', JSON_OBJECT('name', name), 3 'orders', order_count 4 ) AS data 5 FROM customers;
Object bersarang.
Hasil
(nested JSON structure)
