Schema
import { pgTable, serial, text, integer } from 'drizzle-orm';
export const users = pgTable('users', {
id: serial('id').primaryKey(),
name: text('name').notNull(),
logins: integer('logins').notNull().default(0),
});To increment the number of logins (logins) for a user, use the update (update) query. In this example, we increment the logins value by 1 for the user with id = 1.
Increment value
import { eq, sql } from 'drizzle-orm';
const id = 1
await db
.update(users)
.set({
logins: sql`${users.logins} + 1`,
})
.where(eq(users.id, id));