Thus far, our efforts to utilize database data have been limited to pulling data from the database. We've looked at how to select data, how to limit it based on conditions, and how to sort it. However, we've only worked with data that already existed in our
Companylink database, which was created back in Chapter 1, SQL and Relational Databases when you ran the
companylink_db.cmd batch file. In this chapter, we examine some of the types of statements that were actually used in that script. These commands allow us to create and modify data in our Companylink database.
In this chapter, we shall: