Q. What is the value of val2 in the following MySQL statement?
UPDATE t SET val1 = val1 + 2, val2 = val1;
-
(A)
previous val1
-
(B)
DROP
-
(C)
unchanged
-
(D)
val1 + 1
✅ Correct Answer: (B)
DROP
Explanation: This MySQL statement uses the UPDATE command to modify the values in a table named 't'. Let's break down what's happening: