12 replies

Delete limit

Hi, how do I delete just 1 row from a table?

// Example:
db.delete(dogs).where(eq(dogs.breed, 'husky')).limit(1)

// Example:
db.delete(dogs).where(eq(dogs.breed, 'husky')).limit(1)

Delete limit - Drizzle Team