Assuming you are using "column" and "table" keywords for brevity and mistakenly posted the script more than once, there is a closing parentheses ")" missing after the "Name" Column.
Also are you sure that ID & Name have the same data type and are the intended columns to compare the values? Moreover, what error you are prompted with?
After re-formatting the question I realize that the OP wants to update multiple columns
@callvey You can certainly update multiple columns in one update statement like
According to the latest information