Relational Database Design and Implementation, 4th Edition

Chapter 20

Data Modification

Abstract

This chapter covers SQL statements for inserting, modifying, and deleting data. It includes a discussion of the effect of deleting data on referential integrity, as well as merging data (updating on a condition).

Keywords

SQL

SQL INSERT

SQL UPDATE

SQL DELETE

SQL MERGE

SQL data modification

SQL includes commands for modifying the data in tables: INSERT, UPDATE, and DELETE. In many business environments, application programs provide forms-driven data modification, removing the need for end users to issue SQL data modification statements directly to the DBMS. (As you will see, this is a good thing because using SQL data modification statements are rather clumsy.) Nonetheless, if you are developing and testing database ...