Update Command

Update statement in SQL is used to modify the data of an existing table. We can modify a single cell value or entire column values in a table. We can modify a group of columns values also.


Syntax:
UPDATE <tablename> SET col1 = val1, col2 = val2,... WHERE condition

Example:
To modify all values under the password column
UPDATE EmployeeInfo SET [Password]='111'

SELECT * FROM EmployeeInfo;

To modify one employee password column

UPDATE EmployeeInfo SET [Password]='112' where  ID=2;

SELECT * FROM EmployeeInfo;

To modify one employee password,Empdept column

UPDATE EmployeeInfo SET [Password]='112',EmpDept=3 where ID=2;

SELECT * FROM EmployeeInfo;