Sams Teach Yourself SQL in 21 Days, Fourth Edition

Summary

SQL provides three statements that you can use to manipulate data within a database.

The INSERT statement has two variations. The INSERT...VALUES statement inserts a set of values into one record. The INSERT...SELECT statement is used in combination with a SELECT statement to insert multiple records into a table based on the contents of one or more tables. The SELECT statement can join multiple tables, and the results of this join can be added to another table.

The UPDATE statement changes the values of one or more columns and should be based on some condition. Otherwise you might update all rows when you only intended to update specific rows. The updated value can also be the result of an expression or calculation.

The DELETE statement ...