CO$3$: Introduction to relational databases and MySQL

CO$4$: How to use PHP with a MySQL database

Prompt

This exercise will give you a chance to use phpMyAdmin to review the data$-$bases that are used with this book and to test the types of SQL statements that you will use in your PHP applications. Complete Chapter $3$ Exercise $3-1$ Use phpMyAdmin with a database, take a screenshot as you complete each step:

$6.$ Select the my$\_$guitar$\_$shop$1$ database to display the tables for this database, and click the Browse button to view the data for the products table.

$7.$ Click the Structure tab to view the column definitions for the products table. Note that none of the columns allow a null value or provide a default value. Run SQL statements against the my$\_$guitar$\_$shop$1$ database

$8.$ Use the SQL tab to run the first query in figure $3-4.$ Then, run the second query.

$9.$ Run the query in figure $3-5.$ Then, modify the list price value in the query so it only selects products with a price that$$s less than $400,$ and run the query again.

$10.$ Run the first query in figure $3-6$ to add a row to the products table. Then, browse the products table to view the new row. Last, run a DELETE statement to delete the new row.