Data Manipulation Language
Once we've created tables using DDL, we use DML to add, modify, delete, and query the data. In the process of creating and exploring our database, we've had a chance to become briefly acquainted with a few of these commands already.
This is the set of SQL
DML statements that we will learn to use in this section:
|Adding, changing, and deleting data|
|Transaction control statements|
If you've followed the examples in the last section, you no longer have the CD_COLLECTION and SONGS tables that were created earlier in this last chapter. If you followed ...