Sams Teach Yourself SQL in One Hour a Day, Fifth Edition

LESSON 11Manipulating Data

In this lesson, we discuss data manipulation. By the end of this lesson, you should understand

• How to manipulate data using the INSERT, UPDATE, and DELETE commands

• The importance of using the WHERE clause when you are manipulating data

• The basics of importing and exporting data from foreign data sources

Introducing Data-Manipulation Statements

Up to this point, you have learned how to retrieve data from a database using every selection criterion imaginable. After this data is retrieved, you can use it in an application program or edit it. Part 1 focused on retrieving data. However, you might have wondered how to enter data into the database in the first place. You might also be wondering what to do with data ...