Kysely: Updating data

Join the AI Workshop to learn more about AI and how it can be applied to web development. Next cohort February 1st, 2026

The AI-first Web Development BOOTCAMP cohort starts February 24th, 2026. 10 weeks of intensive training and hands-on projects.

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 id=1 WHERE name='test';