import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/deps.ts";
const { QueryCreator } = kysely;
Creates a delete query.
See the {@link DeleteQueryBuilder.where} method for examples on how to specify a where clause for the delete operation.
The return value of the query is an instance of DeleteResult.
Examples
Delete a single row:
const result = await db
.deleteFrom('person')
.where('person.id', '=', '1')
.executeTakeFirst()
console.log(result.numDeletedRows)
The generated SQL (PostgreSQL):
delete from "person" where "person"."id" = $1
Some databases such as MySQL support deleting from multiple tables:
const result = await db
.deleteFrom(['person', 'pet'])
.using('person')
.innerJoin('pet', 'pet.owner_id', '=', 'person.id')
.where('person.id', '=', 1)
.executeTakeFirst()
The generated SQL (MySQL):
delete from `person`, `pet`
using `person`
inner join `pet` on `pet`.`owner_id` = `person`.`id`
where `person`.`id` = ?
Parameters
from: TR[]
Returns
DeleteQueryBuilder<DB, ExtractTableAlias<DB, TR>, DeleteResult>
Parameters
tables: TR[]
Returns
DeleteQueryBuilder<From<DB, TR>, FromTables<DB, never, TR>, DeleteResult>
Parameters
from: TR
Returns
DeleteQueryBuilder<DB, ExtractTableAlias<DB, TR>, DeleteResult>
Parameters
table: TR
Returns
DeleteQueryBuilder<From<DB, TR>, FromTables<DB, never, TR>, DeleteResult>