Data Updation and Deletion

Updation and deletion of data are also part of SQL's Data Manipulation Language (DML). In this section, we apply these two data manipulation methods — UPDATE and DELETE — on the STUDENT and GUARDIAN tables given in section 9.4.

The UPDATE statement (covered in 9.7.1) modifies the value(s) of one or more columns of existing record(s) in a table, and the DELETE statement (covered in 9.7.2) removes one or more entire records from a table. Both commands rely on the WHERE clause to target exactly the row(s) that should be affected — …