Question: 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

MYSQL Chapter 5 How to insert, update, and delete data Exercises

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 INSERT statement so MySQL automatically generates the category_id column. Write an UPDA TE statement that modifies the row you just added to the Categories table. This statement should change the product_name column to "Woodwinds", 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 2. 3. 4. Write an INSERT statement that adds this row to the Products table: product id category id: product_code product name: description: list price: The next automatically generated ID 4 dgx 640 Yamaha DGX 640 88-Key Digital Piano Long description to come. 799.99 discount percent Today's date/time. date added 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%. Write a DELETE statement that deletes the record with category_id 4 from the Categories table. 5. 6. When you execute this statement, it will produce an error since the category has related rows in the Products table. To fix that, precede the DELETE statement with another DELETE statement that deletes all products in this category. (Remember that to code two or more statements in a script, you must end each statement with a semicolon.)

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!

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...

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. * *...

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...

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...

Using the My Guitar Shop database you installed in Module 1 , develop the following queries. To test whether a table has been modified correctly as you do these exercises, you can write and run an...

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...

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...

MYSQL Chapter 6 How to code summary queries Exercises 1. Write a SELECT statement that returns these columns The count of the number of orders in the Orders table The sum of the tax_ amount columns...

Refer to Cornerstone Exercise 10.4. Required: 1. If Carreker, Inc., has a transfer pricing policy that requires transfer at full product cost, what would the transfer price be? Do you suppose that...

Design an active first-order highpass filter with H(s) = -100s/ s + 10, s = j Use a 1-F capacitor.

what to include in net income when you meet earnout?

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...

3. Have you taken course work in project management? What do you know about process documentation?

Knowledge of process documentation (process flow charting)

3. What management, organization, and technology issues did Arup have to address when selecting Project Online as its global project portfolio management tool?