General MySQL Oracle SQL Server

JSON_MERGE() - Synonym for JSON_MERGE_PRESERVE()

Q

What's the difference between JSON_MERGE() and JSON_MERGE_PRESERVE() functions?

✍: FYIcenter.com

A

JSON_MERGE(json1, json2, ...) is a synonym for the JSON_MERGE_PRESERVE(json1, json2, ...) function.

Note that JSON_MERGE() was: 

  Introduced before MySQL 5.7.
  Deprecated in MySQL 8.0.

Related MySQL functions:

 

⇒ JSON_MERGE_PATCH() - Merging JSON by Replacing Members

⇐ JSON_LENGTH() - Calculating Length of JSON Value

⇑ MySQL Functions on JSON Values

⇑⇑ MySQL Function References

2023-12-13, 1141🔥, 0💬

General MySQL Oracle SQL Server