Update
Update is used to modify the existing records in a table. You can use where
with update to filter target records.
Sql
Update Table_Name
Set
column1 = value1,
column2 = value2,
Where
column3=some_value
and
column4=some_another_value;
JsStore
var noOfRowsUpdated = await connection.update({
in: "Table_Name",
set: {
column1: value1,
column2: value2
},
where: {
column3: some_value,
column4: some_another_value
}
});
alert(noOfRowsUpdated + ' rows updated');