update.md

< Index

Update

You can update rows of a table using an update statement:

db(update(tab).
   .set(tab.gamma = false, tab.textN = std::nullopt)
   .where(tab.id = 17);

update

The update function takes a single raw table as its argument.

set

The set function has to be called with one or more assignments as its arguments. The left sides of these assignments have to be columns of the table mentioned above.

set arguments can be dynamic. Note that if all arguments are dynamic with false conditions, the statement becomes invalid.

where

The where clause specifies which rows should be affected.

where can be called with a dynamic argument. In case the dynamic condition is false, no WHERE will be included in the serialized statement.

< Index