在MySQL中,使用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