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 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 data ...