KeywordUPDATE

UPDATE tableSET prop1= value1, ...WHERE condition

alasql("UPDATE events SET synchronized = ? WHERE name = ?",[true,event.name]);alasql('UPDATE cities SET population = population * 1.5 WHERE name LIKE "A%"');alasql('UPDATE city SET population = LEN(name) * 1000000 WHERE name LIKE "M%"');

OUTPUT Clause

// Return the new valuesalasql('UPDATE cities SET population = population * 1.5 WHERE name = "Paris" OUTPUT INSERTED.*');// Return the old valuesalasql('UPDATE cities SET population = population * 1.5 WHERE name = "Paris" OUTPUT DELETED.*');// Return both old and new valuesalasql('UPDATE cities SET population = population * 1.5 WHERE name = "Paris" OUTPUT DELETED.population AS old_pop, INSERTED.population AS new_pop');