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 orderdetails SET quantity quantity
What happens if we run this command in MySQL
a
The quantity in the orderdetails table for all records is incremented by
b
The quantity in the orderdetails table for all records is decremented by
c
An error is thrown due to the
d
The orderdetails 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
