Define update statement

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

Example :

Update Employees set EmployeeName = ‘Peter Heines’ where EmployeeName = ‘Peter’

This Query will modify the Employee name “Peter” into “Peter Heines”

The data can be updated in several columns like,

Update Employees set Address = ‘134 Gandhi Nagar’ , City = ‘Bangalore’ where EmployeeName

= ‘James Roguer’

This Query will modify the Address and City of the Employee with name ““James Roguer”