add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select JSON_REPLACE('{"k1":[{"id":1,"name":"guna","age":34},{"id":2,"name":"guna1","age":34},{"id":3,"name":"guna2","age":34}]}',
'$.k1[0]',
'{"id":1,"name":"guna","age":34,"hi":"hi"}');
JSON_REPLACE('{"k1":[{"id":1,"name":"guna","age":34},{"id":2,"name":"guna1","age":34},{"id":3,"name":"guna2","age":34}]}',
                    '$.k1[0]',
                    '{"id":1,"name":"guna","age":34,"hi":"hi"}')
{"k1": ["{"id":1,"name":"guna","age":34,"hi":"hi"}", {"id": 2, "age": 34, "name": "guna1"}, {"id": 3, "age": 34, "name": "guna2"}]}
select JSON_REPLACE('{"k1":[{"id":1,"name":"guna","age":34},{"id":2,"name":"guna1","age":34},{"id":3,"name":"guna2","age":34}]}',
'$.k1[0]',
CAST('{"id":1,"name":"guna","age":34,"hi":"hi"}' AS JSON));
JSON_REPLACE('{"k1":[{"id":1,"name":"guna","age":34},{"id":2,"name":"guna1","age":34},{"id":3,"name":"guna2","age":34}]}',
                    '$.k1[0]',
                    CAST('{"id":1,"name":"guna","age":34,"hi":"hi"}' AS JSON))
{"k1": [{"hi": "hi", "id": 1, "age": 34, "name": "guna"}, {"id": 2, "age": 34, "name": "guna1"}, {"id": 3, "age": 34, "name": "guna2"}]}