What Is The Value Of Val2 In The Following Mysql Statementp Pre #157
What is the value of val2 in the following MySQL statement?</p> <pre><code class="language-sql"> UPDATE t SET val1 = val1 + 2, val2 = val1;</code></pre>
This multiple choice question (MCQ) is related to the book/course
gs gs113 MySQL.
It can also be found in
gs gs113 Using SQL to Manage Data - Multipleable Deletes and Updates - Quiz No.1.
What is the value of val2 in the following MySQL statement?
UPDATE t SET val1 = val1 + 2, val2 = val1;
previous val1
updated val1
unchanged
val1 + 1
Similar question(s) are as followings:
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113 MySQL
Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113 MySQL
Online Quizzes
