In this lesson, we discuss data manipulation. By the end of this lesson, you should understand
• How to manipulate data using the
• The importance of using the
WHERE clause when you are manipulating data
• The basics of importing and exporting data from foreign data sources
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 ...