MySQL Basics In Pictures

Practice: Running Queries

Task: The Dean wants a report from the hardware database that lists the type of computer each student received, and the date it was received.

Create a query that gives him this information.

  1. Connect to the MySQL database server, using your MySQL root password.
  2. Using the hardware database, write a query that shows four things:
    • the date the computer was given out
    • the first name of the student
    • the last name of the student
    • a description of the computer
  3. Run the query.

    The output should look something like this:

  4. Close the MySQL database connection and exit the terminal window.