Skip to main content

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');

Example