UPDATE & Delete Statement Update Statement: UPDATE statement is used to modify the existing records in a table.with We need to use Where Clause with Update statement to update the selected row,otherwise all the rows would be affected. The Update Statement look like : UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition]; If anyone forget to use Where Clause then the total row will be updated. So use Where clause with Update statement. Delete Statement: The Delete Statement use to delete the existing record in a table.We need to use Where Clause with Delete Statement,Otherwise all the rows would be affected. The Statement look like: DELETE FROM table_name WHERE condition ;