Daita
  • Introduction
  • Getting started
  • Usage
    • relational
      • SELECT
      • INSERT
      • UPDATE
      • DELETE
      • Schema
        • CREATE SCHEMA
      • Table
        • CREATE TABLE
        • ALTER TABLE
        • DROP TABLE
        • LOCK TABLE
      • View
        • CREATE VIEW
        • DROP VIEW
      • Index
        • CREATE INDEX
        • DROP INDEX
      • Functions
        • Aggregation
          • AVG
          • COUNT
          • MAX
          • MIN
          • SUM
        • Conditional
          • CASE WHEN
          • COALESCE
          • GREATEST
          • LEAST
        • Date
          • DAY OF MONTH
          • DAY OF WEEK
          • DAY OF YEAR
          • HOUR
          • MINUTE
          • MONTH
          • NOW
          • SECOND
          • WEEK OF YEAR
          • YEAR
        • Numeric
          • CEIL
          • FLOOR
          • ROUND
        • String
          • CONCAT
    • ORM
    • cli
  • Adapters
    • pg-adapter
    • sqlite-adpater
    • mariadb-adpater
    • http-adpater
Powered by GitBook
On this page
  1. Usage
  2. relational

DELETE

const result = await client.delete({
   delete: table(Mountain),
   where: equal(field(Mountain, 'country'), 'CH'),
});
// sql: DELETE FROM "Mountain" WHERE "Mountain"."country" = 'CH'
//
// const result: { deletedRows: number }
PreviousUPDATENextSchema

Last updated 3 years ago