Chapter 17. Updating Tables

17.1 Introduction

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

image 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 will 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 ...

Get SQL for MySQL Developers: A Comprehensive Tutorial and Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.