JSON_MERGE_PATCH

1
SELECT JSON_MERGE_PATCH(
2
  '{"name": "Budi", "age": 30, "city": "Jakarta"}',
3
  '{"age": 31, "email": "budi@email.com"}'
4
) as merged;

1
SELECT JSON_MERGE_PATCH(
2
  '{"name": "Budi", "age": 30, "temp": "to_remove"}',
3
  '{"temp": null, "new_field": "added"}'
4
) as result;

1
SELECT JSON_MERGE_PATCH(
2
  '{"user": {"name": "Budi", "settings": {"theme": "light", "lang": "id"}}}',
3
  '{"user": {"settings": {"theme": "dark"}}}'
4
) as updated;