Database Reference
In-Depth Information
Counters and upserts
We'll also note that our earlier
UPDATE
statement attempted to increment a column in a
upsert operation; the
UPDATE
statement actually creates the row and increments the values
accordingly. Not surprisingly, if we attempt to increment a counter column that doesn't yet
have a value, its initial value is considered zero.