UPDATE

• table_name: The target table of the data to be updated. Can be in the form of ‘db_name.table_name’
• where expression: The condition to be updated is an expression that returns true or false

The table is a unique model table, which contains four columns: k1, k2, v1, v2. Among them, k1, k2 are keys, v1, v2 are values, and the aggregation method is Replace.

1. Update the v1 column that satisfies the conditions k1 =1 and k2 = 2 in the’test’ table to 1

1. Increment the v1 column of the column with k1=1 in the’test’ table by 1