The update statement in all the versions of SQL will be like:
set col1 = expr1,
col2 = expr2,
. . .
coln = exprn
where some condition
Therefore, the answer is that you separate the assignments using commas and don't repeat the set statement.
Want to know more about SQL? Join this SQL Course by Intellipaat.