SQL SET Keyword

SET Keyword

Previous

Next

Set

The SET

command is used with UPDATE to specify which columns and values that should be updated in a table.

The following SQL updates the first customer (CustomerID = 1) with a new ContactName and a new City:

Example

UPDATE Customers

WHERE CustomerID = 1;
The following SQL will update the "ContactName" field to "Juan" for all records where Country is "Mexico":

Example

UPDATE Customers

WHERE Country='Mexico';

Note:

UPDATE statement.
The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated!

Previous

Next