O'Reilly logo

Sams Teach Yourself SQL in One Hour a Day, Fifth Edition by Arie D. Jones, Ron Plew, Ryan Stephens

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

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

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