kysely.DeleteQueryBuilder | /mod.ts | kysely_postgrs_js_dialect@v0.27.4

method kysely.DeleteQueryBuilder.prototype.limit

import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/mod.ts";
const { DeleteQueryBuilder } = kysely;

limit(limit: ValueExpression<DB, TB, number>): DeleteQueryBuilder<DB, TB, O>

Adds a limit clause to the query.

A limit clause in a delete query is only supported by some dialects like MySQL.

Delete 5 oldest items in a table:

await db
  .deleteFrom('pet')
  .orderBy('created_at')
  .limit(5)
  .execute()

Parameters

limit: ValueExpression<DB, TB, number>