Question: MySQL help QUESTION: Write an UPDATE statement that modifies two columns within the row that you added in Question 3 above. This statement should change

MySQL help

QUESTION:

Write an UPDATE statement that modifies two columns within the row that you added in Question 3 above. This statement should change the list price to $689.99 and the discount percent to 40%. BE SURE to have the $ and % in the updated values.

"Question 3":

Write an INSERT statement using a column list to add this row to the products_copy table. Pay careful attention to the comments below.

MySQL help QUESTION: Write an UPDATE statement that modifies two columns within

My code for question 3:

INSERT INTO products_copy (Product_id, Category_id, Product_code, Product_name, Description, list_price, discount_percent, date_added) VALUES( 11, 4, 'Y_PK100', 'YAMAHA PK-100', 'The Yamaha PK-100 88-key weighted action digital piano has a Graded Hammer Standard Action, 192-note Polyphony, 24 Sounds, Stereo Sound System, EQ, and Drum Patterns/Virtual Accompaniment - Black', 800.00, 20.00, NOW());

the row that you added in Question 3 above. This statement should

Product_id: 11 Category_id: 4 Product_code: Y_PK100 Product_name: Yamaha PK-100 Description: The Yamaha PK-100 88-key weighted action digital piano has a Graded Hammer Standard Action, 192-note Polyphony, 24 Sounds, Stereo Sound System, EQ, and Drum Patterns/Virtual Accompaniment - Black list_price: 800.00 discount_percent: 20.00 date_added: /*Do not hard code the date and time; use a function that will insert the date and time at the moment when the record is added. */ my_guitar_shop Tables addresses addresses_copy administrators categories customers customers_copy order_items orders products products_copy Columns product_id category_id product_code product_name description list_price discount_percent date_added Indexes Foreign Keys Triggers Views Stored Procedures Functions

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!