Golang Delete Rows PostgreSQL MySQL

• API
• Example
• Bulk-delete
• DELETE ... USING

API

To see the full list of supported methods, see DeleteQuery.

db.NewDelete().
    With("cte_name", subquery).

    Model(&strct).
    Model(&slice).

    Table("table1", "table2"). // quotes table names
    TableExpr("table1 AS t1"). // arbitrary unsafe expression
    TableExpr("(?) AS alias", subquery).
    ModelTableExpr("table1 AS t1"). // overrides model table name

    WherePK(). // where using primary keys
    Where("id = ?", 123).
    Where("name LIKE ?", "my%").
    Where("? = 123", bun.Ident("id")).
    Where("id IN (?)", bun.In([]int64{1, 2, 3})).
    Where("id IN (?)", subquery).
    Where("FALSE").WhereOr("TRUE").
    WhereGroup(" AND ", func(q *bun.SelectQuery) *bun.SelectQuery {
        return q.WhereOr("id = 1").
            WhereOr("id = 2")
    }).

    Returning("*").
    Returning("col1, col2").
    Returning("NULL"). // don't return anything

    Exec(ctx)

Example

To delete a row, define a model and use DeleteQuery:

res, err := db.NewDelete().Where("id = ?", 123).Exec(ctx)

Bulk-delete

To bulk-delete books by a primary key:

books := []*Book{book1, book2} // slice of books with ids
res, err := db.NewDelete().Model(&books).WherePK().Exec(ctx)

DELETE FROM "books" WHERE id IN (1, 2)

DELETE ... USING

To delete rows using another table:

res, err := db.NewDelete().
    Model((*Book)(nil)).
    TableExpr("archived_books AS src").
    Where("book.id = src.id").
    Exec(ctx)

DELETE FROM "books" AS book
USING archived_books AS src
WHERE book.id = src.id