> > >

MySQL MCQs

What is the correct syntax for updating a table using LEFT OUTER JOIN?

UPDATE T1 LEFT JOIN T2 ON T2.ID = T1.ID SET T1.COL1 = NEWVALUE WHERE T2.ID IS NULL

UPDATE T1 LEFT JOIN T2 SET T1.COL1 = NEWVALUE ON T2.ID = T1.ID WHERE T2.ID IS NULL

UPDATE T1 LEFT JOIN T2 ON T2.ID = T1.ID WHERE T2.ID IS NULL SET T1.COL1 = NEWVALUE

UPDATE T1, T2 LEFT JOIN ON T2.ID = T1.ID SET T1.COL1 = NEWVALUE WHERE T2.ID IS NULL

Answer

Correct Answer: UPDATE T1 LEFT JOIN T2 ON T2.ID = T1.ID SET T1.COL1 = NEWVALUE WHERE T2.ID IS NULL

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it