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

Exercise 41. Updating with SQL

You now know the CR parts of CRUD, which leaves the update and delete operations. As with all the other SQL commands, the UPDATE command follows a format similar to DELETE, but it changes the columns in rows instead of deleting them.

Click here to view code image

ex9.sql

1    UPDATE person SET first_name = "Hilarious Guy" 2        WHERE first_name = "Zed"; 3 4    UPDATE pet SET name = "Fancy Pants" 5        WHERE id=0; 6 7    SELECT * FROM person; 8    SELECT * FROM pet;

In the above code I’m changing my name to “Hilarious Guy,” since that’s more accurate. And to demonstrate my new moniker I renamed my Unicorn to “Fancy Pants.” He loves it.

This shouldn’t be that hard to figure out but, just in case, I’m going ...