Definition :

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

Syntax :

UPDATE tablename SET(columnname1=value1, columnname2 =value2, columnname3=value3, columnname4=value4, columnname5=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");

 5,051 total views,  1 views today

Categories: SQL

0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.