clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335770 fiddles created (27473 in the last week).

SELECT VERSION();
VERSION()
8.0.26
 hidden batch(es)


SET @`default_values` := JSON_OBJECT( 'a', 1, 'b', 2, 'c', 3, 'd', 4 );
 hidden batch(es)


SELECT JSON_PRETTY( JSON_MERGE_PATCH( @`default_values`, JSON_OBJECT( 'a', 5, 'e', 6 ) ) );
JSON_PRETTY( JSON_MERGE_PATCH( @`default_values`, JSON_OBJECT( 'a', 5, 'e', 6 ) ) )
{ "a": 5, "b": 2, "c": 3, "d": 4, "e": 6 }
 hidden batch(es)