Chapter 20. Updating and Deleting Data

In this chapter, you will learn how to use the UPDATE and DELETE statements to enable you to further manipulate your table data.

Updating Data

To update (modify) data in a table the UPDATE statement is used. UPDATE can be used in two ways:

  • To update specific rows in a table

  • To update all rows in a table

Let’s take a look at each of these uses.

Caution

Don’t Omit the WHERE ClauseSpecial care must be exercised when using UPDATE because it is all too easy to mistakenly update every row in your table. Please read this entire section on UPDATE before using this statement.

Tip

UPDATE and SecurityUse of the UPDATE statement can be restricted and controlled. More on this in Chapter 28, “Managing Security.”

The UPDATE

Get MySQL® Crash Course 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.