SQL For Dummies, 8th Edition

Chapter 6

Manipulating Database Data

In This Chapter

Dealing with data

Retrieving the data you want from a table

Displaying only selected information from one or more tables

Updating the information in tables and views

Adding a new row to a table

Changing some or all of the data in a table row

Deleting a table row

Chapters 3 and 4 reveal that creating a sound database structure is critical to maintaining data integrity. The stuff you’re really interested in, however, is the data itself — not its structure. At any given time, you probably want to do one of four things with data: add it to tables, retrieve and display it, change it, or delete it from tables.

In principle, database manipulation is quite simple. Understanding how to add data to a table isn't difficult — you can add your ...