To delete items from a table, use .deleteFrom():
await db
.deleteFrom('tablename')
.where('id', '=', 1)
.execute()
This corresponds to the SQL query:
DELETE FROM tablename WHERE id=1;
Lessons in this unit:
| 0: | Introduction |
| 1: | Installing Kysely |
| 2: | Select queries |
| 3: | Inserting data |
| 4: | ▶︎ Deleting data |
| 5: | Updating data |
| 6: | Joins |