DML statement-Update

nThe UPDATE statement is used to modify the data in a table.

nThe SET clause names the columns you want to update and provide the values you want to change

Syntax:

UPDATE table_name
SET column1=value, column2=value2,...
WHERE column1=some_value AND column2=some_value

Query:

UPDATE EMPtbl1

SET EMPname=‘Chris’

WHERE EMPname=‘Batista' AND Location=‘Bangalore’