CMPS 160: Databases

Introduction

In this module, we will learn about how to insert, update and utilize delete statements in SQL (Structured Query Language) in MySQL Workbench.

Module Objectives

• Create a copy of the table that can be used for testing INSERT, UPDATE, and DELETE statements.
• Learn the specifications for an action that modifies data.
• Learn the default behavior when an INSERT, UPDATE, or DELETE statement is executed.

Learning Resources

• Module 4 Readings: Chapter 5
• Module 4 Slides: Chapter 5

Learning Activities

• Module 4 Quiz: Chapter 5

For Further Study