Question

Which UPDATE query can modify values of more than one column?

Cosmo · Accepted Answer

UPDATE query has the following structure in case of several columns being updated:

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Cosmo · Accepted Answer

UPDATE table_name SET col1_name = 'col1_val', col2_name = 'col2_val';

Cosmo · Answer

One query can update only values in one column

Cosmo · Answer

UPDATE table_name SET col1_name = 'col1_val' and SET col2_name = 'col2_val';

Cosmo · Answer

UPDATE table_name SET col1_name = 'col1_val' SET col2_name = 'col2_val';