MySQL 8 Administrator???s Guide

Partial updates of JSON values

What should we do if we want to update a value in a JSON document stored in a JSON data type? One of the approaches is to remove the old document and insert a new document, with updates. The approach doesn't seem good, right? MySQL 8.0 supports partial, in place update of a JSON document stored in a JSON data type column. The optimizer requires that an update must meet the following conditions:

• The column must be of JSON type.
• One of three functions, JSON_SET(), JSON_REPLACE() or JSON_REMOVE(), can be used to update the column. MySQL doesn't permit direct assignment of the column value as a partial update.
• The input column and target column must be the same. For example, a statement such as UPDATE temp SET ...