Update table rows

To change the value of rows in an existing table, use the UPDATE command. You can update specific rows or all the rows in a table.

You cannot update columns that are used as distribution keys for a table. When you update rows, you specify the table, columns, and an optional search condition (WHERE).

To update the temperature readings as of November 28, 1994, enter:

   MYDB.SCHEMA(USER)=> UPDATE weather SET temp_hi = temp_hi - 2, temp_lo = 
temp_lo - 2 WHERE date > '1994-11-28';