DT
Drizzle Team•15mo ago
fi

How to plus 1 to the current value of a column when update

How to plus 1 to the current value of a column when updating a record
2 Replies
fi
fi•15mo ago
do i need to read the value first then only update it?
Andrii Sherman
Andrii Sherman•15mo ago
You can use sql template 
db.update(usersTable).set({
    field: sql`${usersTable.field} + 1`
})
db.update(usersTable).set({
    field: sql`${usersTable.field} + 1`
})
Want results from more Discord servers?
Add your server
More Posts
Ordering by a string column but coercing it to a number for orderingI have a column that mostly contains numbers with only a very few exceptions and want to apply ordertype union on entire rowi can think of workarounds for this but figured i'd ask if i have a table that's like [id, type, daProper query results inferencePosting my GitHub discussion here for more visibility: https://github.com/drizzle-team/drizzle-orm/dDrizzle with Next 13.4.2 & Vercel Postgres TimeoutHi all. I'm trying out NextJS server actions and Drizzle for the first time. I have it hooked up tI think I don't really understand migrations local sqlite.It's a local sqlite db (`DB_URL=file:dev.db`) in a nextjs & trpc setup. I'm trying drizzle for the fConnecting to Vercel PostgresI'm trying to connect to Vercel Postgres like this: ```ts import { drizzle } from "drizzle-orm/verce