Absolute Beginner’s Guide to Databases

Modify Data with the Insert, Update, and Delete Statements

Your introduction to SQL is nearly complete. The only elements left are the portions of the Data Definition Language that allow you to Add, Modify, and Delete data. The SQL statements that facilitate these operations are the Insert, Update, and Delete statements. This section provides a brief introduction to these SQL DML components. As you will see, the Insert, Update, and Delete statements are very simple and easy to understand.

The Insert Statement

The Insert statement consists of three parts. The first part designates the table you want to affect. The second part is a listing of fields. The third part is a listing of the actual data. The following code illustrates how an Insert ...