Chapter 6

Manipulating Database Data

In This Chapter

arrow Dealing with data

arrow Retrieving the data you want from a table

arrow Displaying only selected information from one or more tables

arrow Updating the information in tables and views

arrow Adding a new row to a table

arrow Changing some or all of the data in a table row

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

Get SQL For Dummies, 8th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.