Skip to content

Update

Jump to bottom
Andrey Gershun edited this page May 28, 2015 · 10 revisions

UPDATE

AlaSQL supports UPDATE statement.

Syntax:

    UPDATE table SET prop1 = value1, ... WHERE condition

For example:

    alasql('UPDATE cities SET population = population * 1.5 WHERE name LIKE "A%"');
    alasql('UPDATE city SET population = LEN(name) * 1000000 WHERE name LIKE "M%"');

See also: DELETE, INSERT

© 2014-2024, Andrey Gershun & Mathias Rangel Wulff

Please help improve the documentation by opening a PR on the wiki repo

Quick links

Clone this wiki locally