Let's delete this new row back out
of the database:
DELETE FROM ANTIQUES
WHERE ITEM = 'Ottoman';
But if there is another
row that contains 'Ottoman', that
row will be deleted also. Let's delete
all rows (one, in this case) that
contain the specific data we added
before:
DELETE FROM ANTIQUES
WHERE ITEM = 'Ottoman' AND BUYERID
= 01 AND SELLERID = 21; |