SQL Update statement is used to modify the records in table in database . We can modify either by change data or deleting data or to update the existing data .
We can modify the rows based on condition and condition come with where clause . Syntax :
update table_name set column_name = value1 ,............column_nameN = valueN , where clause ;