Instance Methodgrdb 7.3.0GRDB

set(to:)

Returns an assignment of this column to an SQL expression.

QueryInterfaceRequest.swift:1310
func set(to value: (any SQLExpressible)?) -> ColumnAssignment

For example:

Column("valid").set(to: true)
Column("score").set(to: 0)
Column("score").set(to: nil)
Column("score").set(to: Column("score") + Column("bonus"))

For convenience, the last assignment can also be written as:

Column("score") += Column("bonus")

Usage:

try dbQueue.write { db in
    // UPDATE player SET score = 0
    try Player.updateAll(db, Column("score").set(to: 0))
}