Summary

In this chapter, you've looked at how you can use SQL to make modifications to the data stored in database tables. Specifically, you've seen the following:

• How to use INSERT statements to add one or more rows

• How to change row data using UPDATE

• How to use DELETE to remove rows from a table

In the next chapter you'll look at using SQL to deal with multiple rows of data simultaneously, grouping data, and summarizing data.