Update Table

UPDATE table         SET column1 = expression1              ,  column2 = expression2,              ,  ...  WHERE conditions; ou UPDATE table1    SET column1 = (SELECT expression1                     FROM table2                    WHERE conditions)  WHERE conditions;