Update statement

Update statement builder can be used to update records in a table. The table to be updated is provided during construction of the Update statement.

final update = Update('person');

Setting columns values

Use setValue method to set a column in the record.

final update= Update('person').setValue('age', 29);

Use setValues method to set multiple columns with a single call.

final update = Update('person').setValues({
  'name': 'Teja',
  'age': 29,
});

The above statement is equivalent to:

UPDATE person SET name='Teja', age=29;

Use setInt, ``setString, setBool` and `setDateTime` methods to set columns values in a type safe manner.

Filtering

TODO

Executing the statement

Use the exec method to execute an insert statement.

final insert = Insert('person').setValues({
  'name': 'Teja',
  'age': 29,
});

await insert.exec(adapter);