1.Write an INSERT statement that adds this row to the Categories table:
| category_name: | Drums |
Code the INSERT statement so MySQL automatically generates the category_id column.
2.Write an INSERT statement that adds this row to the Instruments table:
| instrument_id | The next automatically generated ID |
| category_id | 5 |
| instrument_code | sd1200 |
| instrument_name | Simmons SD1200 Electronic Drum Kit with Mesh Pads |
| 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.
3.Write an UPDATE statement that modifies the instrument you added in exercise 2. This state-ment should change the discount_percent column from 0% to 35%.
4.Write a DELETE statement that deletes the Drums category. When you execute this statement, it will produce an error since the category has related rows in the Instruments table. To fix that, precede the DELETE statement with another DELETE statement that deletes all instruments in this category.
5.Write an INSERT statement that adds this row to the Musicians table:
| email_address | rick@csueb.com |
| password | (empty string) |
| first_name | Rick |
| last_name | Raven |
6.Write an UPDATE statement that modifies the Musicians table. Change the password column to "secret" for the musician with an email address of rick@csueb.com .
7.Write an UPDATE statement that modifies the Musicians table. Change the password column to "reset" for every musician in the table. If you get an error due to safe-update mode, you can add a LIMIT clause. (This should update all rows in the table.)