Updating a Table › Modifying Data in a Table with SET

Modifying Data in a Table with SET

You use the UPDATE statement to modify columns or rows in a table.

Modifying Values in a Column

If you want to modify every value in a column throughout the table, you need to:

Identify the table you intend to modify by specifying UPDATE and the table name

Name the column in which the modification is to take place and give the new data with a SET clause

How It's Done

At certain times during the year, every employee's accrued vacation is increased by eight hours.