Updating a Table

Goal

When you have completed this chapter, you will be able to store rows of data in a table and change and delete existing data in a table.

Summary

Up to this time, you have been retrieving data that exists in a table in the database. Now you are going to add, modify, and delete rows of data in a table. The statements you will use are:

INSERT, to add a row of data to a table
UPDATE, to change the values in one or more columns in all rows of a table or in rows that satisfy a search condition
DELETE, to remove one or more rows from a table

This section contains the following topics:

Inserting Data into a Table

Modifying Data in a Table with SET

Removing Data from a Table

Review