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
💬 Discuss
✅ 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:

Published by Ritu Nagar ⭐ 4.39K Points at 22-Mar-2025 12:44 pm in MySQL

Explanation by: Ritu Nagar
This MySQL statement uses the UPDATE command to modify the values in a table named 't'. Let's break down what's happening:

💬 Discussion

📊 Question Analytics

👁️
143
Total Visits
📽️
1 y ago
Published
🎖️
Ritu Nagar
Publisher
📈
89%
Success Rate