Using the MySQL workbench 8.0 CE Modifying Tables Using the My Guitar Shop database , develop the following queries. To test whether a table has been modified correctly as you do these exercises, you

Using the MySQL workbench 8.0 CE

order now

Modifying Tables

Using the My Guitar Shop database , develop the following queries.

To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement.

  1. Write an INSERT statement that adds this row to the Categories table:

category_name:               Brass

Code the INSERT statement so MySQL automatically generates the category_id column. Execute the query and take a screenshot of the query and the results.

  1. Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the category_name column to “Woodwinds,” and it should use the category_id column to identify the row. Execute the query and take a screenshot of the query and the results.
  2. Write a DELETE statement that deletes the row you added to the Categories table in exercise 1. This statement should use the category_id column to identify the row. Execute the query and take a screenshot of the query and the results.
  3. Write an INSERT statement that adds this row to the Products table:

product_id:        The next automatically generated ID

category_id:       4

product_code:   dgx_640

category_name:    Yamaha DGX 640 88-Key Digital Piano

description:        Long description to come.

list_price:            799.99

discount_percent:           0

date_added:      Today’s date/time.

Use a column list for this statement. Execute the query and take a screenshot of the query and the results.