Counter column
Counter columns are special, in that they can only be updated, not inserted.
Prerequisites
This example shows a count column called popularity updated by adding 2 to the current count:
UPDATE cycling.popular_count SET popularity = popularity + 2
WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;