Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 5. Manipulating Data
Data Manipulation Language (DML) is the part of SQL that allows a database user to actually propagate changes among data in a relational database. With DML, the user can populate tables with new data, update existing data in tables, and delete data from tables. Simple database queries can also be performed within a DML command.
There are three basic DML commands in SQL:
INSERT UPDATE DELETE
The SELECT command, which can be used with DML commands, is discussed in more detail in Hour 7, "Introduction to the Database Query." The SELECT command is the basic query command that can be used after data has been entered into the database with the INSERT command.