• Introduction
  • 1. How to Retrieve Data From a Single Table
  • 2. How to Retrieve Data from Multiple Tables
  • 3. Using Functions
  • 4. How to Insert, Update, Delete Data in Tables
  • 5. Summary Queries and Aggregate Functions
  • 6. Working With Subqueries
  • 7. SQL Views
  • 8. SQL Indexes
  • Glossary
  • Index
  • Download
  • Translations
  • 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';



    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.