How to merge JSON documents in MySQL
You can merge two JSON documents in MySQL with:
- the
JSON_MERGE_PRESERVEfunction to concatenate the document values - the
JSON_MERGE_PATCHfunction to keep the latest value for each key
Mastodon Francesco comes from Verona, Italy and works as a Staff Developer Advocate at Aiven. With his many years of experience as a data analyst, he has stories to tell and advice for data-wranglers everywhere. Francesco loves sharing knowledge with others as a speaker and writer, and is on a mission to defend the world from bad Italian food!