In this lesson, you will learn how to use the UPDATE and DELETE statements to enable you to further manipulate your table 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 Clause
Special care must be exercised when using
UPDATE because it is all too easy to mistakenly update every row in your table. Please ...