DELETE

For WHERE examples, please see the WHERE section.

Delete all rows

import { useD1 } from 'cl-orm';

const db = useD1(env.DB);

await db.delete({
  from: 'temp',
});

SQL Query

DELETE FROM `temp`

---

Limit the rows to be deleted

import { useD1 } from 'cl-orm';

const db = useD1(env.DB);

await db.delete({
  from: 'test',
  limit: 1,
});

SQL Query

DELETE FROM `test` LIMIT ?
-- params: [1]