O'Reilly logo

Absolute Beginner’s Guide to Databases by John V. Petersen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required