Kysely: Updating data

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';

Lessons this unit:

0: Introduction
1: Installing Kysely
2: Select queries
3: Inserting data
4: Deleting data
5: ▶︎ Updating data
6: Joins