In the past six days, you have seen how to retrieve data from the database by using the SELECT statement along with a variety of optional parameters. After this data is retrieved, you can use it in your application program or edit it. So far, the focus has been on retrieving the data. However, you might have wondered how to enter data into the database in the first place.
Today, you will learn several ways of manipulating the data within the database. These topics include
Creating tables
Inserting rows
Updating rows
Deleting rows