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