Database Reference
In-Depth Information
Figure 15.5
Two Updates to the
Same Row with a
SAVEPOINT
Label Between the
Updates.
ROLLBACK TO SAVEPOINT AFTERUPDATE;
SELECT ARTIST_ID, NAME, ZIP FROM ARTIST
WHERE NAME = 'Mud Puddle';
SELECT ARTIST_ID, NAME, ZIP FROM ARTIST
WHERE NAME = 'Puddle of Mudd';
Finally, we can undo the remaining change from the first UPDATE
command and end the transaction using a ROLLBACK command.
The rest of this chapter deals with making changes to the database using
DML commands to add, change, and remove data. We begin with the
INSERT command.
