UPDATE YourTable
SET Col1 = OtherTable.Col1,
Col2 = OtherTable.Col2
FROM (
SELECT ID, Col1, Col2
FROM other_table) AS OtherTable
WHERE
OtherTable.ID = YourTable.ID
UPDATE sakila.actor # table to update
SET first_name = "Bryan", last_name = "Besmond" # fields to be added/updated
WHERE actor_id = 201; # boolean condition