Chapter 6

Manipulating Database Data

IN THIS CHAPTER

Bullet Dealing with data

Bullet Retrieving the data you want from a table

Bullet Displaying only selected information from one or more tables

Bullet Updating the information in tables and views

Bullet Adding a new row to a table

Bullet Changing some or all the data in a table row

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

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

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