Jan 09, 2019 · Basic Syntax. UPDATE table_name SET column1 = value1, column2 = value2,... WHERE condition; table_name: name of the table column1: name of first , second, third column....value1: new value for first, second, third column....condition: condition to select the rows for which the values of columns needs to be updated.. NOTE: In the above query the SET …