To practice your new MySQL skills, you’re going to run a few additional queries on your new
[objects] database table in your
You can run all of the queries below in the phpMyAdmin interface. And make sure you use the Common MySQL Queries & Query Commands Cheatsheet for reference!
1. Selecting specific pieces of information
Pick two of your
[objects] table’s columns.
Write a query to retrieve all your objects, selecting only those two columns’ values.
2. Select all objects using a string comparison
Pick one of the
TEXT columns in your
Pick a word, or phrase, contained in that value of column for one or more of your objects. (E.g. I have a
title column; my first object’s title is
Then write a query to select all of your objects that contain that chosen string. (Hint: use the
3. Insert a new object using a query
INSERT query to insert a new, third object with all required pieces of information.
4. Delete that new object
Sorry! It’s time to delete your new object.
DELETE query to remove the newly-inserted, third object, referencing its
5. Update your first object
Using the same column you chose for #2, let’s call it
Write a query to alter your first object’s