The SQL UPDATE Statement

The UPDATE TABLE statement is used to update records of the table in the database.

Syntax



    UPDATE table_name
    SET column_name1 = new_value,
    column_name2 = new_value,
    ...
    [WHERE Condition];

Output

The column parameters specify the names of the columns of the table.

The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.).