Update DML Statements

Definition :

• This statement is used to modify/change/update the existing record/s or data in the database.

Syntax :

UPDATE table–name SET(column–name1=value1, column–name2 =value2, column–name3=value3, column–name4=value4, column–name5=value5 ) ;

Example :

UPDATE employee SET(emp_id="125M", emp_name="Rahman", emp_addr ="Kolkata", emp_dept="Manager", emp_dob="05/22/2020", emp_sal=20500, emp_mob=9334582186);

UPDATE employee SET(emp_name="Rahman", emp_addr ="Kolkata", emp_dept="Manager", emp_dob="05/22/2020", emp_sal=20500, emp_mob=9334582186 where emp_id= "105M");