DT

Drizzle Team•2y ago

Mick

How to reuse values within update().set() ? How to increment int?

How may I reuse values from the current item within .update.set()? E.g. how can I do the following PostgreSQL query?

UPDATE totals 
   SET total = total + 1
WHERE name = 'bill';

UPDATE totals 
   SET total = total + 1
WHERE name = 'bill';

The docs has barely any informations about

.update()

.update()