Chapter 5 How to Insert, Update, and Delete Data Write an INSERT statement that adds this row to the Categories table category name Percussion Code the INSERT statement so MySQL automatically generates the category id column Write an UPDATE statement that modifies the Percussion row you just added to the Categories table This statement should change the category name column to Woodies, and it should use the category id column to identify the row 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 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 product name Yamaha DGX 640 88 Key Digital Piano description Long description to come list price 944 25 discount percent 0 date added Todays date time Use a column list for this statement Write an UPDATE statement that modifies the product you added in exercise 4 This statement should change the discount percent column from 0 to 35 categories seleSELECT categories category id , categories category name FROM my guitar shop categories ct

The Answer is in the image, click to view ...

Question: Chapter 5: How to Insert, Update, and Delete Data Write an INSERT statement that adds this row to the Categories table: category_name: Percussion Code the

Chapter 5: How to Insert, Update, and Delete Data

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

category_name: Percussion

Code the INSERT statement so MySQL automatically generates the category_id column.

Write an UPDATE statement that modifies the Percussion row you just added to the Categories table. This statement should change the category_name column to Woodies, and it should use the category_id column to identify the row.
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.
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 product_name: Yamaha DGX 640 88-Key Digital Piano description: Long description to come. list_price: 944.25 discount_percent: 0 date_added: Todays date/time.

Use a column list for this statement.

Write an UPDATE statement that modifies the product you added in exercise 4. This statement should change the discount_percent column from 0% to 35%.

*categories

seleSELECT `categories`.`category_id`, `categories`.`category_name` FROM `my_guitar_shop`.`categories`;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The invoice ID is 115. I keep getting a duplicate error message. INSERT INTO invoice_line_items VALUES (115, 1, 160, 180.23, 'Hard drive'), (115, 2, 527, 254.35, 'Exchange Server update'); How do I...

MYSQL Chapter 5 How to insert, update, and delete data Exercises appropriate SELECT statement. 1. Write an INSERT statement that adds this row to the Categories table: Brass category name Code the...

Chapter 7 How to insert, update, and delete data Exercises To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. * *...

Insert, update, and delete data Use your copy of the ap database: _ap If you need to restore the database to the original state, you can modify and run the create_db_ap script to restore it. To test...

HW5: Chapters 7&8 How to insert, update, and delete data Exercises To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT...

Learning Activity 6 : Insert, update, and delete data Setup: Use create _ ap . sql to create database 1 . Write SELECT INTO statements to create two test tables named VendorCopy and InvoiceCopy that...

Select all rows and columns from the hospital _ basic table. 2 ) Select all the rows and columns from hospital _ basic where the Physician is not Molly Clock. ( 3 9 rows ) 3 ) Select all rows and...

QUESTION 1 Assuming that all of the table and column sames are spelled correctly, what's wrong with the INSERT statement that follows? INSERT INTO invoices (vendor id, invoice number, invoice total,...

Captain E. Garth Beaver has been warned by Colonel Sy Verleaf that if the mean efficiency rating for the 150 platoons under Verleaf s command falls below 80, Captain Beaver will be transferred to...

Write a one page paper on Event Planning and Catering Business in which described: Describe the industry and the type of business you plan to start. Provide specific details, such as the location,...

The following cost dats relate to the mandfacturing activites of Chang Company during the jast cangleted year: The comparty unes a pridetermined ovethead rabe of $ 2 5 per machine - hour to acply...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

What would be the shared Data Elements between Position Control and Salary Grade Tables in providing cost input to Budgets for vacant positions?

What is the purpose of the Salary Structure Table?

What is the scope and use of a Job Family Table?