Database Reference
In-Depth Information
Chapter 8. Updating and Deleting Data
Data in databases will change often. There's always something to change, some bit of in-
formation to add, some record to delete. For these situations in which you want to change
or add pieces of data, you will mostly use the
UPDATE
statement. For situations in which
you want to delete an entire row of data, you'll primarily use the
DELETE
statement. Both
of these SQL statements are covered extensively in this chapter.