DELETE

Delete Single Record

import (
    "github.com/si3nloong/sqlike/v2/actions"
    "github.com/si3nloong/sqlike/v2/sql/expr"
    "context"

    _ "github.com/go-sql-driver/mysql"
)

func main() {
    result, err := client.
        Database("sqlike").
        Table("Users").
        DeleteOne(
            context.Background(),
            actions.DeleteOne().
                Where(
                    expr.Equal("ID", 123),
                ),
        )
    if err != nil {
        panic(err)
    }
}

Delete Single Record using Primary Key

user := User{
    Name: "Sian Loong",
    Age: 18,
    Birthday: time.Now(),
}

result, err := client.
    Database("sqlike").
    Table("Users").
    DestroyOne(context.Background(), &user)
if err != nil {
    panic(err)
}

Delete Multiple Record

import (
    "github.com/si3nloong/sqlike/v2/actions"
    "github.com/si3nloong/sqlike/v2/sql/expr"
    "context"

    _ "github.com/go-sql-driver/mysql"
)

func main() {
    result, err := client.
        Database("sqlike").
        Table("Users").
        Delete(
            context.Background(),
            actions.Delete().
                Where(
                    expr.Equal("Status", "frozen"),
                ),
        )
    if err != nil {
        panic(err)
    }
}

Beware

Delete without condition (where clause) will throw error.