UPDATE
Previous  Next


UPDATE table_name SET column_1 = value_1, column_2 = value_2, ... column_n = value_n [ WHERE condition1 [ [ AND | OR ] condition2 ] ... ]

This statement will update table rows relative to table table_name with respect to the criteria specified by the WHERE clause; if no WHERE clause is specified, all table rows will be updated.

Note: calculated values are allowed