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 in this unit:
| 0: | Introduction |
| 1: | Installing Kysely |
| 2: | Select queries |
| 3: | Inserting data |
| 4: | Deleting data |
| 5: | ▶︎ Updating data |
| 6: | Joins |