In databases, data update is to add, delete, or modify data. Timely data update is an important part of high-quality data services.
Technically speaking, there are two types of data updates: you either update a whole row (Row Update) or just update part of the columns (Partial Column Update). Many databases support both of them but in different ways. This post is about one of them, which is simple in execution and efficient in data quality guarantee.