The SQL UPDATE Query is used to modify the existing records in a table.
You can use WHERE clause with UPDATE query to update selected rows otherwise all the rows would be effected.
Syntax Of Update Query:
The basic syntax of UPDATE query with WHERE clause is as follows:[sql] UPDATE table_name
SET column1 = value1, column2 = value2…., columnN = valueN