In this chapter we study the Data Manipulation Language (DML) part of SQL that is used to make changes to the data inside a relational database. The three basic commands of DML are as follows.
INSERT Populates tables with new data
UPDATE Updates existing data
DELETE Deletes data from tables
We have already seen a few examples on the INSERT statement including simple inserts, selective field insertions, and null value inserts. Thus we will concentrate on other ways to use this statement.
Inserting Data into a Table from Another Table
You can insert new records into a table from another one by using a combination ...
