Learn More Python 3 the Hard Way: The Next Step for New Python Programmers

Exercise 42. Deleting with SQL

This is the simplest exercise, but I want you to think for a second before typing the code in. If you had “SELECT * FROM” for SELECT, and “INSERT INTO” for INSERT, then how would you write the DELETE format? You can probably glance down, but try to guess at what it would be, then look.

Click here to view code image

ex7.sql

 1    /* make sure there's dead pets */  2    SELECT name, age FROM pet WHERE dead = 1;  3  4    /* aww poor robot */  5    DELETE FROM pet WHERE dead = 1;  6  7    /* make sure the robot is gone */  8    SELECT * FROM pet;  9 10   /* let's resurrect the robot */ 11   INSERT INTO pet VALUES (1, "Gigantor", "Robot", 1, 0); 12 13   /* the robot LIVES! */ 14   SELECT * FROM pet;

I’m simply implementing ...