Question: Consider the following command: UPDATE order _ details SET quantity = quantity - - 1 0 What happens if we run this command in MySQL

Consider the following command:
UPDATE order_details SET quantity = quantity --10
What happens if we run this command in MySQL?
a.)
The quantity in the order_details table for all records is incremented by 10.
b.)
The quantity in the order_details table for all records is decremented by 10.
c.)
An error is thrown due to the --.
d.)
The order_details table has all of the quantity set to the same value as it previously had.

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!