Update Query

UPDATE:- it is used to change the values of the table rows
Syntax:-          1 update tablename set columname=exp,columname=exp;
                        2 update tablename set columname=exp,--- where condition;
Ex:-                 1 update vision set sal=sal+1000;
                        2 update vision set sal=sal+1000 where eno=100;

3 update vision set sal=sal*110/100,na=’prasad’ where eno=100;