ftisiot ideas about food and life
who talks suggestions soft json-pg json-mysql

merge

Jul 21, 2023

How to merge JSON documents in MySQL

You can merge two JSON documents in MySQL with:

  • the JSON_MERGE_PRESERVE function to concatenate the document values
  • the JSON_MERGE_PATCH function to keep the latest value for each key

Continue Reading


Francesco Tisiot

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!

Story logo

© 2023