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:
Examine the concept of DML—Data Manipulation Language
Create data using the
INSERT
statementCopy data using
INSERT
/SELECT
Modify data using the
UPDATE
statementRemove data using the
DELETE
statementExamine transaction control
Learn to recognize and debug errors