SQL Update and Delete Lab
Now that you've learned how to update and delete data from a table, let's practice.
Objectives
- Practice updating data in a table using WHERE clauses
- Practice deleting data from a table through WHERE clauses
Todo
Pass the few specs by writing your SQL statements in lib/update.sql
and lib/delete.sql
. The data you'll see in the lib/insert.sql
should be familiar from the last lab.