MySQLÂ includes a number of functions for working with JSON documents. Among these are the JSON_MERGE_PATCH()
and JSON_MERGE_PRESERVE()
functions.
Both of these functions merge two or more JSON documents and return the result. However, there are certain cases where these functions will return a different result. You need to be aware of this before including them in any of your queries.