JSON
MySQL
JSON_ARRAY_INSERT
MySQLMenyisipkan nilai di posisi tertentu dalam array JSON. Elemen setelahnya bergeser ke kanan.
Tipe hasil:
JSONDiperbarui: 7 Jan 2026Syntax
SQL
JSON_ARRAY_INSERT(json_doc, path, val[, path, val] ...)Parameter
json_docJSONwajib
JSON document sumber
pathVARCHARwajib
Path dengan index array ($.arr[index])
valanywajib
Nilai yang akan disisipkan
Contoh Penggunaan
Insert at Index
SQL
1 SELECT JSON_ARRAY_INSERT('["a", "b", "c"]', '$[1]', 'x') AS result;
Menyisipkan 'x' di index 1.
Hasil
["a", "x", "b", "c"]
Insert at Beginning
SQL
1 SELECT JSON_ARRAY_INSERT('[1, 2, 3]', '$[0]', 0) AS result;
Menyisipkan di awal array (unshift).
Hasil
[0, 1, 2, 3]
Insert in Nested Array
SQL
1 SELECT JSON_ARRAY_INSERT('{"items": [1, 2, 3]}', '$.items[1]', 1.5) AS result;
Menyisipkan di nested array.
Hasil
{"items": [1, 1.5, 2, 3]}