Kysely: Updating data

Join the AI Workshop and learn to build real-world apps with AI. A hands-on, practical program to level up your skills.

To update data in a table, use .updateTable():

await db
  .updateTable('tablename')
  .values({ name: 'test' })
  .where('id', '=', 1)
  .execute()

This corresponds to the SQL query:

UPDATE tablename SET name='test' WHERE id=1;