4.4

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.

Code Sample:

1    USE world; 
2    UPDATE city 
3    SET Population = 65000, district = 'Aconcagua';

Results:

iud_04.png

UPDATE city


SET Population = 65000, district = 'Aconcagua';

This content is provided to you freely by EdTech Books.

Access it online or download it at https://edtechbooks.org/learning_mysql/the_update_clause_wiv.