Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition

Chapter 14. Updating Tables

Introduction

SQL offers various statements for updating the contents (the column values in the rows) of tables—statements for inserting new rows, for changing column values, and for deleting rows. This chapter describes the extensive features of these statements.

Note

In most examples of this book, we assume that the tables contain their original contents. If you execute the statements discussed in this chapter, you change the contents of the tables. Consequently, the results of your statements in the next examples can differ from those in the book. On the Web site of the book, www.r20.nl, you can read how to restore the original contents of the tables after an update.

Inserting New Rows

In SQL, you can use the INSERT statement ...