SQL: UPDATE

Update

The UPDATE command in SQL is a DML (Data Manipulation Language) command. Other DML commands are: INSERT and DELETE.

Example: Update a record in the Employee table

	UPDATE Employee
	SET EmployeeLastName = 'Smith', City= 'New York'
	WHERE EmployeeID = 419031;
	

Output:

Example: Update many record in the Customers table

The SQL command below will update any records in the Customers table who live in the state of Michigan with a telephone area code of 818. Their area code will be changed to 213.

	UPDATE Customers
	SET    AreaCode = 213
	WHERE  State = 'MI" 
	AND    AreaCode = 818  
	

Output: