The UPDATE Clause With a Column List
The UPDATE Clause
- You can UPDATE single or multiple rows at a time.
- In a SET clause, you define the column along with its new value that may be a literal value or an expression.
- You can update one or all of the columns in a row.
- You can use a subquery or WHERE clause in an UPDATE statement.
1 USE world;
2 UPDATE city
3 SET Population = 65000, district = 'Aconcagua';
- You indicate the table you want to UPDATE.
SET Population = 65000, district = 'Aconcagua';
- You indicate the table columns and associated values you want to change them to by using the equals sign ( = ).
- You must separate each column and value with a comma.
- There is no trailing comma
End-of-Chapter Survey: How would you rate the overall quality of this chapter?
- Very Low Quality
- Low Quality
- Moderate Quality
- High Quality
- Very High Quality