Update & Delete Query

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;