Golang 删除行 PostgreSQL MySQL

• API
• 示例
• 批量删除
• DELETE ... USING

API

要查看支持方法的完整列表，请参阅 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)

示例

要删除一行，请定义一个 模型 并使用 DeleteQuery

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

批量删除

要通过主键批量删除书籍

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

要使用另一个表删除行

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