NEED HELP ! (delete and update a row in Astro DB)

[nimble kite]

Hello @flat spear you can update rows using the builtin methods that Drizzle offers e.g to update:

await db.update(users)
  .set({ name: 'Mr. Dan' })
  .where(eq(users.name, 'Dan'));

to delete:

await db.delete(users).where(eq(users.name, 'Dan'));

https://orm.drizzle.team/docs/delete#sql-delete

[flat spear]

Thank you